Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 112372 |
| Missing cells | 173691 |
| Missing cells (%) | 3.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 35.2 MiB |
| Average record size in memory | 328.0 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 27 |
date_initial has constant value "2016-09-04" | Constant |
dummy has constant value "1" | Constant |
customer_id has a high cardinality: 97917 distinct values | High cardinality |
customer_unique_id has a high cardinality: 94721 distinct values | High cardinality |
customer_city has a high cardinality: 4108 distinct values | High cardinality |
order_id has a high cardinality: 97917 distinct values | High cardinality |
order_purchase_timestamp has a high cardinality: 97371 distinct values | High cardinality |
order_approved_at has a high cardinality: 89534 distinct values | High cardinality |
order_delivered_carrier_date has a high cardinality: 80450 distinct values | High cardinality |
order_delivered_customer_date has a high cardinality: 95022 distinct values | High cardinality |
order_estimated_delivery_date has a high cardinality: 450 distinct values | High cardinality |
product_id has a high cardinality: 32789 distinct values | High cardinality |
seller_id has a high cardinality: 3090 distinct values | High cardinality |
shipping_limit_date has a high cardinality: 92643 distinct values | High cardinality |
review_id has a high cardinality: 97709 distinct values | High cardinality |
review_comment_title has a high cardinality: 4497 distinct values | High cardinality |
review_comment_message has a high cardinality: 35692 distinct values | High cardinality |
review_creation_date has a high cardinality: 633 distinct values | High cardinality |
review_answer_timestamp has a high cardinality: 97547 distinct values | High cardinality |
product_category_name has a high cardinality: 73 distinct values | High cardinality |
date_achat has a high cardinality: 616 distinct values | High cardinality |
Unnamed: 0 is highly overall correlated with diff_days and 2 other fields | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
price is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_weight_g is highly overall correlated with price and 3 other fields | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_width_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
diff_days is highly overall correlated with Unnamed: 0 and 2 other fields | High correlation |
score_rfm is highly overall correlated with Unnamed: 0 and 2 other fields | High correlation |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
score_rec is highly overall correlated with Unnamed: 0 and 1 other fields | High correlation |
order_status is highly imbalanced (93.4%) | Imbalance |
score_freq is highly imbalanced (94.2%) | Imbalance |
order_delivered_carrier_date has 1184 (1.1%) missing values | Missing |
order_delivered_customer_date has 2360 (2.1%) missing values | Missing |
review_comment_title has 98938 (88.0%) missing values | Missing |
review_comment_message has 64730 (57.6%) missing values | Missing |
product_category_name has 1598 (1.4%) missing values | Missing |
product_name_lenght has 1598 (1.4%) missing values | Missing |
product_description_lenght has 1598 (1.4%) missing values | Missing |
product_photos_qty has 1598 (1.4%) missing values | Missing |
Unnamed: 0 is uniformly distributed | Uniform |
customer_id is uniformly distributed | Uniform |
customer_unique_id is uniformly distributed | Uniform |
order_id is uniformly distributed | Uniform |
order_purchase_timestamp is uniformly distributed | Uniform |
order_approved_at is uniformly distributed | Uniform |
order_delivered_carrier_date is uniformly distributed | Uniform |
order_delivered_customer_date is uniformly distributed | Uniform |
shipping_limit_date is uniformly distributed | Uniform |
review_id is uniformly distributed | Uniform |
review_answer_timestamp is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Reproduction
| Analysis started | 2023-02-10 10:44:50.724028 |
|---|---|
| Analysis finished | 2023-02-10 10:45:54.216642 |
| Duration | 1 minute and 3.49 seconds |
| Software version | pandas-profiling vv3.6.2 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
HIGH CORRELATION  UNIFORM  UNIQUE 
| Distinct | 112372 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56185.5 |
| Minimum | 0 |
|---|---|
| Maximum | 112371 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5618.55 |
| Q1 | 28092.75 |
| median | 56185.5 |
| Q3 | 84278.25 |
| 95-th percentile | 106752.45 |
| Maximum | 112371 |
| Range | 112371 |
| Interquartile range (IQR) | 56185.5 |
Descriptive statistics
| Standard deviation | 32439.147 |
|---|---|
| Coefficient of variation (CV) | 0.57735798 |
| Kurtosis | -1.2 |
| Mean | 56185.5 |
| Median Absolute Deviation (MAD) | 28093 |
| Skewness | 0 |
| Sum | 6.313677 × 109 |
| Variance | 1.0522982 × 109 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 74911 | 1 | < 0.1% |
| 74922 | 1 | < 0.1% |
| 74921 | 1 | < 0.1% |
| 74920 | 1 | < 0.1% |
| 74919 | 1 | < 0.1% |
| 74918 | 1 | < 0.1% |
| 74917 | 1 | < 0.1% |
| 74916 | 1 | < 0.1% |
| 74915 | 1 | < 0.1% |
| Other values (112362) | 112362 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 112371 | 1 | |
| 112370 | 1 | |
| 112369 | 1 | |
| 112368 | 1 | |
| 112367 | 1 | |
| 112366 | 1 | |
| 112365 | 1 | |
| 112364 | 1 | |
| 112363 | 1 | |
| 112362 | 1 |
customer_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 97917 |
|---|---|
| Distinct (%) | 87.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 |
|---|---|
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 |
| 10de381f8a8d23fff822753305f71cae | 15 |
| adb32467ecc74b53576d9d13a5a55891 | 15 |
| Other values (97912) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 87758 ? |
|---|---|
| Unique (%) | 78.1% |
Sample
| 1st row | 08c5351a6aca1c1589a38f244edeee9d |
|---|---|
| 2nd row | 08c5351a6aca1c1589a38f244edeee9d |
| 3rd row | 683c54fc24d40ee9f8a6fc179fd9856c |
| 4th row | 86dc2ffce2dfff336de2f386a786e574 |
| 5th row | 86dc2ffce2dfff336de2f386a786e574 |
Common Values
| Value | Count | Frequency (%) |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 0d93f21f3e8543a9d0d8ece01561f5b2 | 12 | < 0.1% |
| 3b54b5978e9ace64a63f90d176ffb158 | 12 | < 0.1% |
| Other values (97907) | 112214 |
Length
| Value | Count | Frequency (%) |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 9eb3d566e87289dcb0acf28e1407c839 | 12 | < 0.1% |
| daf15f1b940cc6a72ba558f093dc00dd | 12 | < 0.1% |
| Other values (97907) | 112214 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 225399 | 6.3% |
| c | 225289 | 6.3% |
| 5 | 225194 | 6.3% |
| 1 | 225081 | 6.3% |
| 6 | 224917 | 6.3% |
| 8 | 224874 | 6.3% |
| 2 | 224823 | 6.3% |
| 7 | 224778 | 6.3% |
| a | 224719 | 6.2% |
| b | 224709 | 6.2% |
| Other values (6) | 1346121 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2246846 | |
| Lowercase Letter | 1349058 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 225194 | |
| 1 | 225081 | |
| 6 | 224917 | |
| 8 | 224874 | |
| 2 | 224823 | |
| 7 | 224778 | |
| 9 | 224677 | |
| 3 | 224639 | |
| 4 | 223963 | |
| 0 | 223900 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 225399 | |
| c | 225289 | |
| a | 224719 | |
| b | 224709 | |
| e | 224522 | |
| d | 224420 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2246846 | |
| Latin | 1349058 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 225194 | |
| 1 | 225081 | |
| 6 | 224917 | |
| 8 | 224874 | |
| 2 | 224823 | |
| 7 | 224778 | |
| 9 | 224677 | |
| 3 | 224639 | |
| 4 | 223963 | |
| 0 | 223900 |
Latin
| Value | Count | Frequency (%) |
| f | 225399 | |
| c | 225289 | |
| a | 224719 | |
| b | 224709 | |
| e | 224522 | |
| d | 224420 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| f | 225399 | 6.3% |
| c | 225289 | 6.3% |
| 5 | 225194 | 6.3% |
| 1 | 225081 | 6.3% |
| 6 | 224917 | 6.3% |
| 8 | 224874 | 6.3% |
| 2 | 224823 | 6.3% |
| 7 | 224778 | 6.3% |
| a | 224719 | 6.2% |
| b | 224709 | 6.2% |
| Other values (6) | 1346121 |
customer_unique_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 94721 |
|---|---|
| Distinct (%) | 84.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 |
|---|---|
| c8460e4251689ba205045f3ea17884a1 | 24 |
| 4546caea018ad8c692964e3382debd19 | 21 |
| c402f431464c72e27330a67f7b94d4fb | 20 |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 |
| Other values (94716) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 82917 ? |
|---|---|
| Unique (%) | 73.8% |
Sample
| 1st row | b7d76e111c89f7ebf14761390f0f7d17 |
|---|---|
| 2nd row | b7d76e111c89f7ebf14761390f0f7d17 |
| 3rd row | 4854e9b3feff728c13ee5fc7d1547e92 |
| 4th row | 830d5b7aaa3b6f1e9ad63703bec97d23 |
| 5th row | 830d5b7aaa3b6f1e9ad63703bec97d23 |
Common Values
| Value | Count | Frequency (%) |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 16 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 33176de67c05eeed870fd49f234387a0 | 15 | < 0.1% |
| 3e43e6105506432c953e165fb2acf44c | 14 | < 0.1% |
| Other values (94711) | 112190 |
Length
| Value | Count | Frequency (%) |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 16 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 33176de67c05eeed870fd49f234387a0 | 15 | < 0.1% |
| 31e412b9fb766b6794724ed17a41dfa6 | 14 | < 0.1% |
| Other values (94711) | 112190 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 225520 | 6.3% |
| 1 | 225456 | 6.3% |
| e | 225081 | 6.3% |
| 8 | 224933 | 6.3% |
| b | 224899 | 6.3% |
| d | 224862 | 6.3% |
| a | 224854 | 6.3% |
| 5 | 224792 | 6.3% |
| 9 | 224775 | 6.3% |
| 2 | 224680 | 6.2% |
| Other values (6) | 1346052 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2247942 | |
| Lowercase Letter | 1347962 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 225520 | |
| 1 | 225456 | |
| 8 | 224933 | |
| 5 | 224792 | |
| 9 | 224775 | |
| 2 | 224680 | |
| 3 | 224650 | |
| 0 | 224625 | |
| 7 | 224466 | |
| 4 | 224045 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 225081 | |
| b | 224899 | |
| d | 224862 | |
| a | 224854 | |
| f | 224279 | |
| c | 223987 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247942 | |
| Latin | 1347962 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 225520 | |
| 1 | 225456 | |
| 8 | 224933 | |
| 5 | 224792 | |
| 9 | 224775 | |
| 2 | 224680 | |
| 3 | 224650 | |
| 0 | 224625 | |
| 7 | 224466 | |
| 4 | 224045 |
Latin
| Value | Count | Frequency (%) |
| e | 225081 | |
| b | 224899 | |
| d | 224862 | |
| a | 224854 | |
| f | 224279 | |
| c | 223987 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 225520 | 6.3% |
| 1 | 225456 | 6.3% |
| e | 225081 | 6.3% |
| 8 | 224933 | 6.3% |
| b | 224899 | 6.3% |
| d | 224862 | 6.3% |
| a | 224854 | 6.3% |
| 5 | 224792 | 6.3% |
| 9 | 224775 | 6.3% |
| 2 | 224680 | 6.2% |
| Other values (6) | 1346052 |
customer_zip_code_prefix
Real number (ℝ)
| Distinct | 14955 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35131.881 |
| Minimum | 1003 |
|---|---|
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3308 |
| Q1 | 11250 |
| median | 24320 |
| Q3 | 59063 |
| 95-th percentile | 90630 |
| Maximum | 99990 |
| Range | 98987 |
| Interquartile range (IQR) | 47813 |
Descriptive statistics
| Standard deviation | 29894.588 |
|---|---|
| Coefficient of variation (CV) | 0.85092477 |
| Kurtosis | -0.79564531 |
| Mean | 35131.881 |
| Median Absolute Deviation (MAD) | 16406 |
| Skewness | 0.77954883 |
| Sum | 3.9478397 × 109 |
| Variance | 8.9368637 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22790 | 151 | 0.1% |
| 22793 | 150 | 0.1% |
| 24220 | 145 | 0.1% |
| 24230 | 137 | 0.1% |
| 22775 | 124 | 0.1% |
| 35162 | 112 | 0.1% |
| 11740 | 106 | 0.1% |
| 29101 | 106 | 0.1% |
| 13212 | 105 | 0.1% |
| 13087 | 104 | 0.1% |
| Other values (14945) | 111132 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 3 | < 0.1% |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99990 | 1 | < 0.1% |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
customer_city
Categorical
| Distinct | 4108 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| sao paulo | |
|---|---|
| rio de janeiro | 7786 |
| belo horizonte | 3150 |
| brasilia | 2402 |
| curitiba | 1749 |
| Other values (4103) |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.338643 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1161774 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1063 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | boa vista |
|---|---|
| 2nd row | boa vista |
| 3rd row | passo fundo |
| 4th row | sao joaquim da barra |
| 5th row | sao joaquim da barra |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 17794 | 15.8% |
| rio de janeiro | 7786 | 6.9% |
| belo horizonte | 3150 | 2.8% |
| brasilia | 2402 | 2.1% |
| curitiba | 1749 | 1.6% |
| campinas | 1642 | 1.5% |
| porto alegre | 1616 | 1.4% |
| salvador | 1393 | 1.2% |
| guarulhos | 1314 | 1.2% |
| sao bernardo do campo | 1067 | 0.9% |
| Other values (4098) | 72459 |
Length
| Value | Count | Frequency (%) |
| sao | 23948 | 12.2% |
| paulo | 17873 | 9.1% |
| de | 10911 | 5.5% |
| rio | 9372 | 4.8% |
| janeiro | 7786 | 4.0% |
| do | 4858 | 2.5% |
| belo | 3220 | 1.6% |
| horizonte | 3178 | 1.6% |
| brasilia | 2412 | 1.2% |
| porto | 1918 | 1.0% |
| Other values (3279) | 111504 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 191445 | |
| o | 143516 | |
| i | 88922 | 7.7% |
| r | 86281 | 7.4% |
| 84608 | 7.3% | |
| e | 75418 | 6.5% |
| s | 71066 | 6.1% |
| n | 51541 | 4.4% |
| u | 50894 | 4.4% |
| l | 50710 | 4.4% |
| Other values (21) | 267373 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1076645 | |
| Space Separator | 84608 | 7.3% |
| Dash Punctuation | 269 | < 0.1% |
| Other Punctuation | 250 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 191445 | |
| o | 143516 | |
| i | 88922 | 8.3% |
| r | 86281 | 8.0% |
| e | 75418 | 7.0% |
| s | 71066 | 6.6% |
| n | 51541 | 4.8% |
| u | 50894 | 4.7% |
| l | 50710 | 4.7% |
| p | 42279 | 3.9% |
| Other values (16) | 224573 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 84608 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 269 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1076645 | |
| Common | 85129 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 191445 | |
| o | 143516 | |
| i | 88922 | 8.3% |
| r | 86281 | 8.0% |
| e | 75418 | 7.0% |
| s | 71066 | 6.6% |
| n | 51541 | 4.8% |
| u | 50894 | 4.7% |
| l | 50710 | 4.7% |
| p | 42279 | 3.9% |
| Other values (16) | 224573 |
Common
| Value | Count | Frequency (%) |
| 84608 | ||
| - | 269 | 0.3% |
| ' | 250 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1161774 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 191445 | |
| o | 143516 | |
| i | 88922 | 7.7% |
| r | 86281 | 7.4% |
| 84608 | 7.3% | |
| e | 75418 | 6.5% |
| s | 71066 | 6.1% |
| n | 51541 | 4.4% |
| u | 50894 | 4.4% |
| l | 50710 | 4.4% |
| Other values (21) | 267373 |
customer_state
Categorical
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 224744 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RR |
|---|---|
| 2nd row | RR |
| 3rd row | RS |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 47399 | |
| RJ | 14468 | 12.9% |
| MG | 13110 | 11.7% |
| RS | 6265 | 5.6% |
| PR | 5736 | 5.1% |
| SC | 4156 | 3.7% |
| BA | 3766 | 3.4% |
| DF | 2416 | 2.2% |
| GO | 2316 | 2.1% |
| ES | 2237 | 2.0% |
| Other values (17) | 10503 | 9.3% |
Length
| Value | Count | Frequency (%) |
| sp | 47399 | |
| rj | 14468 | 12.9% |
| mg | 13110 | 11.7% |
| rs | 6265 | 5.6% |
| pr | 5736 | 5.1% |
| sc | 4156 | 3.7% |
| ba | 3766 | 3.4% |
| df | 2416 | 2.2% |
| go | 2316 | 2.1% |
| es | 2237 | 2.0% |
| Other values (17) | 10503 | 9.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 61269 | |
| P | 57213 | |
| R | 27377 | |
| M | 15973 | 7.1% |
| G | 15426 | 6.9% |
| J | 14468 | 6.4% |
| A | 6438 | 2.9% |
| E | 5888 | 2.6% |
| C | 5720 | 2.5% |
| B | 4362 | 1.9% |
| Other values (7) | 10610 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 224744 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 61269 | |
| P | 57213 | |
| R | 27377 | |
| M | 15973 | 7.1% |
| G | 15426 | 6.9% |
| J | 14468 | 6.4% |
| A | 6438 | 2.9% |
| E | 5888 | 2.6% |
| C | 5720 | 2.5% |
| B | 4362 | 1.9% |
| Other values (7) | 10610 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 224744 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 61269 | |
| P | 57213 | |
| R | 27377 | |
| M | 15973 | 7.1% |
| G | 15426 | 6.9% |
| J | 14468 | 6.4% |
| A | 6438 | 2.9% |
| E | 5888 | 2.6% |
| C | 5720 | 2.5% |
| B | 4362 | 1.9% |
| Other values (7) | 10610 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 224744 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 61269 | |
| P | 57213 | |
| R | 27377 | |
| M | 15973 | 7.1% |
| G | 15426 | 6.9% |
| J | 14468 | 6.4% |
| A | 6438 | 2.9% |
| E | 5888 | 2.6% |
| C | 5720 | 2.5% |
| B | 4362 | 1.9% |
| Other values (7) | 10610 | 4.7% |
order_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 97917 |
|---|---|
| Distinct (%) | 87.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 |
|---|---|
| 8272b63d03f5f79c56e9e4120aec44ef | 21 |
| 1b15974a0141d54e36626dca3fdc731a | 20 |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 |
| Other values (97912) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 87758 ? |
|---|---|
| Unique (%) | 78.1% |
Sample
| 1st row | 2e7a8482f6fb09756ca50c10d7bfc047 |
|---|---|
| 2nd row | 2e7a8482f6fb09756ca50c10d7bfc047 |
| 3rd row | e5fa5a7210941f7d56d0208e4e071d35 |
| 4th row | bfbd0f9bdef84302105ad712db648a6c |
| 5th row | bfbd0f9bdef84302105ad712db648a6c |
Common Values
| Value | Count | Frequency (%) |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| 2c2a19b5703863c908512d135aa6accc | 12 | < 0.1% |
| c05d6a79e55da72ca780ce90364abed9 | 12 | < 0.1% |
| Other values (97907) | 112214 |
Length
| Value | Count | Frequency (%) |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| af822dacd6f5cff7376413c03a388bb7 | 12 | < 0.1% |
| 637617b3ffe9e2f7a2411243829226d0 | 12 | < 0.1% |
| Other values (97907) | 112214 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 225874 | 6.3% |
| 6 | 225416 | 6.3% |
| e | 225362 | 6.3% |
| b | 225319 | 6.3% |
| 7 | 225255 | 6.3% |
| 3 | 225141 | 6.3% |
| a | 224944 | 6.3% |
| 2 | 224842 | 6.3% |
| 8 | 224819 | 6.3% |
| 1 | 224818 | 6.3% |
| Other values (6) | 1344114 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2247355 | |
| Lowercase Letter | 1348549 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 225874 | |
| 6 | 225416 | |
| 7 | 225255 | |
| 3 | 225141 | |
| 2 | 224842 | |
| 8 | 224819 | |
| 1 | 224818 | |
| 9 | 224121 | |
| 0 | 223894 | |
| 5 | 223175 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 225362 | |
| b | 225319 | |
| a | 224944 | |
| c | 224756 | |
| f | 224517 | |
| d | 223651 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247355 | |
| Latin | 1348549 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 225874 | |
| 6 | 225416 | |
| 7 | 225255 | |
| 3 | 225141 | |
| 2 | 224842 | |
| 8 | 224819 | |
| 1 | 224818 | |
| 9 | 224121 | |
| 0 | 223894 | |
| 5 | 223175 |
Latin
| Value | Count | Frequency (%) |
| e | 225362 | |
| b | 225319 | |
| a | 224944 | |
| c | 224756 | |
| f | 224517 | |
| d | 223651 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 225874 | 6.3% |
| 6 | 225416 | 6.3% |
| e | 225362 | 6.3% |
| b | 225319 | 6.3% |
| 7 | 225255 | 6.3% |
| 3 | 225141 | 6.3% |
| a | 224944 | 6.3% |
| 2 | 224842 | 6.3% |
| 8 | 224819 | 6.3% |
| 1 | 224818 | 6.3% |
| Other values (6) | 1344114 |
order_status
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| delivered | |
|---|---|
| shipped | 1110 |
| canceled | 529 |
| invoiced | 358 |
| processing | 352 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9755811 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1008604 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | shipped |
|---|---|
| 2nd row | shipped |
| 3rd row | canceled |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 110013 | |
| shipped | 1110 | 1.0% |
| canceled | 529 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 352 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 110013 | |
| shipped | 1110 | 1.0% |
| canceled | 529 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 352 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 332927 | |
| d | 222026 | |
| i | 112198 | 11.1% |
| l | 110556 | 11.0% |
| v | 110381 | 10.9% |
| r | 110368 | 10.9% |
| p | 2578 | 0.3% |
| s | 1814 | 0.2% |
| c | 1768 | 0.2% |
| n | 1246 | 0.1% |
| Other values (6) | 2742 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1008604 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 332927 | |
| d | 222026 | |
| i | 112198 | 11.1% |
| l | 110556 | 11.0% |
| v | 110381 | 10.9% |
| r | 110368 | 10.9% |
| p | 2578 | 0.3% |
| s | 1814 | 0.2% |
| c | 1768 | 0.2% |
| n | 1246 | 0.1% |
| Other values (6) | 2742 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1008604 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 332927 | |
| d | 222026 | |
| i | 112198 | 11.1% |
| l | 110556 | 11.0% |
| v | 110381 | 10.9% |
| r | 110368 | 10.9% |
| p | 2578 | 0.3% |
| s | 1814 | 0.2% |
| c | 1768 | 0.2% |
| n | 1246 | 0.1% |
| Other values (6) | 2742 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1008604 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 332927 | |
| d | 222026 | |
| i | 112198 | 11.1% |
| l | 110556 | 11.0% |
| v | 110381 | 10.9% |
| r | 110368 | 10.9% |
| p | 2578 | 0.3% |
| s | 1814 | 0.2% |
| c | 1768 | 0.2% |
| n | 1246 | 0.1% |
| Other values (6) | 2742 | 0.3% |
order_purchase_timestamp
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 97371 |
|---|---|
| Distinct (%) | 86.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-10-17 13:06:29 | 22 |
|---|---|
| 2017-07-16 18:19:25 | 21 |
| 2018-02-22 15:30:41 | 20 |
| 2017-01-30 21:44:49 | 15 |
| 2017-11-23 20:30:52 | 15 |
| Other values (97366) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2135068 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 86925 ? |
|---|---|
| Unique (%) | 77.4% |
Sample
| 1st row | 2016-09-04 21:15:19 |
|---|---|
| 2nd row | 2016-09-04 21:15:19 |
| 3rd row | 2016-09-05 00:15:34 |
| 4th row | 2016-09-15 12:16:38 |
| 5th row | 2016-09-15 12:16:38 |
Common Values
| Value | Count | Frequency (%) |
| 2017-10-17 13:06:29 | 22 | < 0.1% |
| 2017-07-16 18:19:25 | 21 | < 0.1% |
| 2018-02-22 15:30:41 | 20 | < 0.1% |
| 2017-01-30 21:44:49 | 15 | < 0.1% |
| 2017-11-23 20:30:52 | 15 | < 0.1% |
| 2017-12-13 14:21:15 | 14 | < 0.1% |
| 2018-02-21 11:45:07 | 14 | < 0.1% |
| 2018-04-12 11:02:51 | 13 | < 0.1% |
| 2017-10-09 20:45:45 | 12 | < 0.1% |
| 2018-01-12 16:19:31 | 12 | < 0.1% |
| Other values (97361) | 112214 |
Length
| Value | Count | Frequency (%) |
| 2017-11-24 | 1366 | 0.6% |
| 2017-11-25 | 580 | 0.3% |
| 2017-11-27 | 480 | 0.2% |
| 2017-11-26 | 452 | 0.2% |
| 2018-08-06 | 430 | 0.2% |
| 2018-08-07 | 429 | 0.2% |
| 2017-11-28 | 428 | 0.2% |
| 2018-05-15 | 420 | 0.2% |
| 2018-05-07 | 417 | 0.2% |
| 2018-05-14 | 412 | 0.2% |
| Other values (51075) | 219330 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 347765 | |
| 0 | 345779 | |
| 2 | 273979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 117176 | 5.5% |
| 112372 | 5.3% | |
| 7 | 104069 | 4.9% |
| 3 | 99198 | 4.6% |
| 5 | 90833 | 4.3% |
| Other values (3) | 194409 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1573208 | |
| Dash Punctuation | 224744 | 10.5% |
| Other Punctuation | 224744 | 10.5% |
| Space Separator | 112372 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 347765 | |
| 0 | 345779 | |
| 2 | 273979 | |
| 8 | 117176 | 7.4% |
| 7 | 104069 | 6.6% |
| 3 | 99198 | 6.3% |
| 5 | 90833 | 5.8% |
| 4 | 90807 | 5.8% |
| 6 | 53371 | 3.4% |
| 9 | 50231 | 3.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224744 |
Space Separator
| Value | Count | Frequency (%) |
| 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2135068 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 347765 | |
| 0 | 345779 | |
| 2 | 273979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 117176 | 5.5% |
| 112372 | 5.3% | |
| 7 | 104069 | 4.9% |
| 3 | 99198 | 4.6% |
| 5 | 90833 | 4.3% |
| Other values (3) | 194409 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2135068 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 347765 | |
| 0 | 345779 | |
| 2 | 273979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 117176 | 5.5% |
| 112372 | 5.3% | |
| 7 | 104069 | 4.9% |
| 3 | 99198 | 4.6% |
| 5 | 90833 | 4.3% |
| Other values (3) | 194409 |
order_approved_at
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 89534 |
|---|---|
| Distinct (%) | 79.7% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 878.0 KiB |
| 2018-02-24 03:20:27 | 23 |
|---|---|
| 2017-10-18 13:06:21 | 22 |
| 2017-07-17 18:25:23 | 21 |
| 2018-06-08 19:31:06 | 15 |
| 2017-12-15 02:30:41 | 15 |
| Other values (89529) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2134783 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 74068 ? |
|---|---|
| Unique (%) | 65.9% |
Sample
| 1st row | 2016-10-07 13:18:03 |
|---|---|
| 2nd row | 2016-10-07 13:18:03 |
| 3rd row | 2016-10-07 13:17:15 |
| 4th row | 2016-09-15 12:16:38 |
| 5th row | 2016-09-15 12:16:38 |
Common Values
| Value | Count | Frequency (%) |
| 2018-02-24 03:20:27 | 23 | < 0.1% |
| 2017-10-18 13:06:21 | 22 | < 0.1% |
| 2017-07-17 18:25:23 | 21 | < 0.1% |
| 2018-06-08 19:31:06 | 15 | < 0.1% |
| 2017-12-15 02:30:41 | 15 | < 0.1% |
| 2017-01-30 22:33:45 | 15 | < 0.1% |
| 2017-11-24 10:31:10 | 15 | < 0.1% |
| 2018-02-22 11:48:42 | 14 | < 0.1% |
| 2018-04-19 22:11:43 | 13 | < 0.1% |
| 2018-04-14 02:31:43 | 13 | < 0.1% |
| Other values (89524) | 112191 | |
| (Missing) | 15 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 2018-04-24 | 1115 | 0.5% |
| 2017-11-24 | 951 | 0.4% |
| 2017-11-25 | 875 | 0.4% |
| 2018-07-05 | 800 | 0.4% |
| 2017-11-28 | 582 | 0.3% |
| 2018-08-07 | 493 | 0.2% |
| 2018-05-08 | 487 | 0.2% |
| 2017-12-05 | 469 | 0.2% |
| 2018-08-20 | 466 | 0.2% |
| 2018-05-15 | 453 | 0.2% |
| Other values (42032) | 218023 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 360517 | |
| 1 | 345025 | |
| 2 | 273152 | |
| - | 224714 | |
| : | 224714 | |
| 112357 | 5.3% | |
| 8 | 111209 | 5.2% |
| 5 | 108307 | 5.1% |
| 3 | 105504 | 4.9% |
| 7 | 99292 | 4.7% |
| Other values (3) | 169992 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1572998 | |
| Dash Punctuation | 224714 | 10.5% |
| Other Punctuation | 224714 | 10.5% |
| Space Separator | 112357 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 360517 | |
| 1 | 345025 | |
| 2 | 273152 | |
| 8 | 111209 | 7.1% |
| 5 | 108307 | 6.9% |
| 3 | 105504 | 6.7% |
| 7 | 99292 | 6.3% |
| 4 | 78126 | 5.0% |
| 6 | 48467 | 3.1% |
| 9 | 43399 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224714 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224714 |
Space Separator
| Value | Count | Frequency (%) |
| 112357 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2134783 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 360517 | |
| 1 | 345025 | |
| 2 | 273152 | |
| - | 224714 | |
| : | 224714 | |
| 112357 | 5.3% | |
| 8 | 111209 | 5.2% |
| 5 | 108307 | 5.1% |
| 3 | 105504 | 4.9% |
| 7 | 99292 | 4.7% |
| Other values (3) | 169992 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2134783 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 360517 | |
| 1 | 345025 | |
| 2 | 273152 | |
| - | 224714 | |
| : | 224714 | |
| 112357 | 5.3% | |
| 8 | 111209 | 5.2% |
| 5 | 108307 | 5.1% |
| 3 | 105504 | 4.9% |
| 7 | 99292 | 4.7% |
| Other values (3) | 169992 |
order_delivered_carrier_date
Categorical
HIGH CARDINALITY  MISSING  UNIFORM 
| Distinct | 80450 |
|---|---|
| Distinct (%) | 72.4% |
| Missing | 1184 |
| Missing (%) | 1.1% |
| Memory size | 878.0 KiB |
| 2018-05-09 15:48:00 | 48 |
|---|---|
| 2018-05-10 18:29:00 | 36 |
| 2017-10-20 19:09:07 | 22 |
| 2018-05-07 12:31:00 | 21 |
| 2018-08-08 15:01:00 | 21 |
| Other values (80445) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2112572 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 62941 ? |
|---|---|
| Unique (%) | 56.6% |
Sample
| 1st row | 2016-10-18 13:14:51 |
|---|---|
| 2nd row | 2016-10-18 13:14:51 |
| 3rd row | 2016-11-07 17:11:53 |
| 4th row | 2016-11-07 17:11:53 |
| 5th row | 2016-11-07 17:11:53 |
Common Values
| Value | Count | Frequency (%) |
| 2018-05-09 15:48:00 | 48 | < 0.1% |
| 2018-05-10 18:29:00 | 36 | < 0.1% |
| 2017-10-20 19:09:07 | 22 | < 0.1% |
| 2018-05-07 12:31:00 | 21 | < 0.1% |
| 2018-08-08 15:01:00 | 21 | < 0.1% |
| 2017-07-20 15:45:53 | 21 | < 0.1% |
| 2018-03-02 00:18:01 | 20 | < 0.1% |
| 2018-06-08 14:40:00 | 19 | < 0.1% |
| 2018-05-10 14:28:00 | 18 | < 0.1% |
| 2018-05-04 15:46:00 | 18 | < 0.1% |
| Other values (80440) | 110944 | |
| (Missing) | 1184 | 1.1% |
Length
| Value | Count | Frequency (%) |
| 2017-11-28 | 878 | 0.4% |
| 2017-11-27 | 762 | 0.3% |
| 2017-11-29 | 675 | 0.3% |
| 2018-02-27 | 612 | 0.3% |
| 2018-03-27 | 588 | 0.3% |
| 2018-08-06 | 579 | 0.3% |
| 2017-11-30 | 551 | 0.2% |
| 2018-08-13 | 531 | 0.2% |
| 2018-05-14 | 530 | 0.2% |
| 2017-12-06 | 515 | 0.2% |
| Other values (37386) | 216155 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 385503 | |
| 1 | 329214 | |
| 2 | 262019 | |
| - | 222376 | |
| : | 222376 | |
| 8 | 117650 | 5.6% |
| 111188 | 5.3% | |
| 7 | 100960 | 4.8% |
| 3 | 93472 | 4.4% |
| 4 | 87465 | 4.1% |
| Other values (3) | 180349 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1556632 | |
| Dash Punctuation | 222376 | 10.5% |
| Other Punctuation | 222376 | 10.5% |
| Space Separator | 111188 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 385503 | |
| 1 | 329214 | |
| 2 | 262019 | |
| 8 | 117650 | 7.6% |
| 7 | 100960 | 6.5% |
| 3 | 93472 | 6.0% |
| 4 | 87465 | 5.6% |
| 5 | 85177 | 5.5% |
| 6 | 48927 | 3.1% |
| 9 | 46245 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 222376 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 222376 |
Space Separator
| Value | Count | Frequency (%) |
| 111188 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2112572 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 385503 | |
| 1 | 329214 | |
| 2 | 262019 | |
| - | 222376 | |
| : | 222376 | |
| 8 | 117650 | 5.6% |
| 111188 | 5.3% | |
| 7 | 100960 | 4.8% |
| 3 | 93472 | 4.4% |
| 4 | 87465 | 4.1% |
| Other values (3) | 180349 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2112572 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 385503 | |
| 1 | 329214 | |
| 2 | 262019 | |
| - | 222376 | |
| : | 222376 | |
| 8 | 117650 | 5.6% |
| 111188 | 5.3% | |
| 7 | 100960 | 4.8% |
| 3 | 93472 | 4.4% |
| 4 | 87465 | 4.1% |
| Other values (3) | 180349 |
order_delivered_customer_date
Categorical
HIGH CARDINALITY  MISSING  UNIFORM 
| Distinct | 95022 |
|---|---|
| Distinct (%) | 86.4% |
| Missing | 2360 |
| Missing (%) | 2.1% |
| Memory size | 878.0 KiB |
| 2017-10-22 14:43:54 | 22 |
|---|---|
| 2017-07-31 18:03:02 | 21 |
| 2018-03-05 15:22:27 | 20 |
| 2017-12-13 20:19:35 | 15 |
| 2017-02-14 10:48:10 | 15 |
| Other values (95017) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2090228 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 84401 ? |
|---|---|
| Unique (%) | 76.7% |
Sample
| 1st row | 2016-11-09 07:47:38 |
|---|---|
| 2nd row | 2016-11-09 07:47:38 |
| 3rd row | 2016-11-09 07:47:38 |
| 4th row | 2016-10-31 11:07:42 |
| 5th row | 2016-10-26 14:02:13 |
Common Values
| Value | Count | Frequency (%) |
| 2017-10-22 14:43:54 | 22 | < 0.1% |
| 2017-07-31 18:03:02 | 21 | < 0.1% |
| 2018-03-05 15:22:27 | 20 | < 0.1% |
| 2017-12-13 20:19:35 | 15 | < 0.1% |
| 2017-02-14 10:48:10 | 15 | < 0.1% |
| 2018-03-01 20:47:01 | 14 | < 0.1% |
| 2017-12-28 09:05:34 | 14 | < 0.1% |
| 2018-04-23 17:47:44 | 13 | < 0.1% |
| 2018-06-18 21:04:38 | 12 | < 0.1% |
| 2018-05-15 19:37:06 | 12 | < 0.1% |
| Other values (95012) | 109854 | |
| (Missing) | 2360 | 2.1% |
Length
| Value | Count | Frequency (%) |
| 2018-05-14 | 512 | 0.2% |
| 2018-08-13 | 498 | 0.2% |
| 2018-05-21 | 496 | 0.2% |
| 2018-08-27 | 494 | 0.2% |
| 2018-05-18 | 488 | 0.2% |
| 2017-12-11 | 476 | 0.2% |
| 2018-04-11 | 470 | 0.2% |
| 2018-05-03 | 463 | 0.2% |
| 2017-06-19 | 460 | 0.2% |
| 2018-07-30 | 454 | 0.2% |
| Other values (41602) | 215213 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 323126 | |
| 0 | 320225 | |
| 2 | 277020 | |
| - | 220024 | |
| : | 220024 | |
| 8 | 129261 | |
| 110012 | 5.3% | |
| 3 | 101890 | 4.9% |
| 7 | 101623 | 4.9% |
| 4 | 95107 | 4.6% |
| Other values (3) | 191916 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1540168 | |
| Dash Punctuation | 220024 | 10.5% |
| Other Punctuation | 220024 | 10.5% |
| Space Separator | 110012 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 323126 | |
| 0 | 320225 | |
| 2 | 277020 | |
| 8 | 129261 | |
| 3 | 101890 | 6.6% |
| 7 | 101623 | 6.6% |
| 4 | 95107 | 6.2% |
| 5 | 89012 | 5.8% |
| 6 | 55431 | 3.6% |
| 9 | 47473 | 3.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 220024 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 220024 |
Space Separator
| Value | Count | Frequency (%) |
| 110012 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2090228 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 323126 | |
| 0 | 320225 | |
| 2 | 277020 | |
| - | 220024 | |
| : | 220024 | |
| 8 | 129261 | |
| 110012 | 5.3% | |
| 3 | 101890 | 4.9% |
| 7 | 101623 | 4.9% |
| 4 | 95107 | 4.6% |
| Other values (3) | 191916 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2090228 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 323126 | |
| 0 | 320225 | |
| 2 | 277020 | |
| - | 220024 | |
| : | 220024 | |
| 8 | 129261 | |
| 110012 | 5.3% | |
| 3 | 101890 | 4.9% |
| 7 | 101623 | 4.9% |
| 4 | 95107 | 4.6% |
| Other values (3) | 191916 |
order_estimated_delivery_date
Categorical
| Distinct | 450 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-12-20 00:00:00 | 607 |
|---|---|
| 2018-03-12 00:00:00 | 593 |
| 2018-05-29 00:00:00 | 591 |
| 2018-03-13 00:00:00 | 589 |
| 2018-07-05 00:00:00 | 571 |
| Other values (445) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2135068 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2016-10-20 00:00:00 |
|---|---|
| 2nd row | 2016-10-20 00:00:00 |
| 3rd row | 2016-10-28 00:00:00 |
| 4th row | 2016-10-04 00:00:00 |
| 5th row | 2016-10-04 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-20 00:00:00 | 607 | 0.5% |
| 2018-03-12 00:00:00 | 593 | 0.5% |
| 2018-05-29 00:00:00 | 591 | 0.5% |
| 2018-03-13 00:00:00 | 589 | 0.5% |
| 2018-07-05 00:00:00 | 571 | 0.5% |
| 2017-12-18 00:00:00 | 565 | 0.5% |
| 2017-12-19 00:00:00 | 565 | 0.5% |
| 2018-05-28 00:00:00 | 563 | 0.5% |
| 2018-02-14 00:00:00 | 558 | 0.5% |
| 2018-05-30 00:00:00 | 557 | 0.5% |
| Other values (440) | 106613 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 112372 | |
| 2017-12-20 | 607 | 0.3% |
| 2018-03-12 | 593 | 0.3% |
| 2018-05-29 | 591 | 0.3% |
| 2018-03-13 | 589 | 0.3% |
| 2018-07-05 | 571 | 0.3% |
| 2017-12-18 | 565 | 0.3% |
| 2017-12-19 | 565 | 0.3% |
| 2018-05-28 | 563 | 0.3% |
| 2018-02-14 | 558 | 0.2% |
| Other values (441) | 107170 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 929457 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 192328 | 9.0% |
| 2 | 175291 | 8.2% |
| 112372 | 5.3% | |
| 8 | 93359 | 4.4% |
| 7 | 68148 | 3.2% |
| 3 | 30055 | 1.4% |
| 5 | 23107 | 1.1% |
| Other values (3) | 61463 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1573208 | |
| Dash Punctuation | 224744 | 10.5% |
| Other Punctuation | 224744 | 10.5% |
| Space Separator | 112372 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 929457 | |
| 1 | 192328 | 12.2% |
| 2 | 175291 | 11.1% |
| 8 | 93359 | 5.9% |
| 7 | 68148 | 4.3% |
| 3 | 30055 | 1.9% |
| 5 | 23107 | 1.5% |
| 6 | 21757 | 1.4% |
| 4 | 21124 | 1.3% |
| 9 | 18582 | 1.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224744 |
Space Separator
| Value | Count | Frequency (%) |
| 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2135068 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 929457 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 192328 | 9.0% |
| 2 | 175291 | 8.2% |
| 112372 | 5.3% | |
| 8 | 93359 | 4.4% |
| 7 | 68148 | 3.2% |
| 3 | 30055 | 1.4% |
| 5 | 23107 | 1.1% |
| Other values (3) | 61463 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2135068 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 929457 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 192328 | 9.0% |
| 2 | 175291 | 8.2% |
| 112372 | 5.3% | |
| 8 | 93359 | 4.4% |
| 7 | 68148 | 3.2% |
| 3 | 30055 | 1.4% |
| 5 | 23107 | 1.1% |
| Other values (3) | 61463 | 2.9% |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1960097 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.69124255 |
|---|---|
| Coefficient of variation (CV) | 0.57795732 |
| Kurtosis | 92.983464 |
| Mean | 1.1960097 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.1912707 |
| Sum | 134398 |
| Variance | 0.47781626 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 98465 | |
| 2 | 9766 | 8.7% |
| 3 | 2270 | 2.0% |
| 4 | 959 | 0.9% |
| 5 | 456 | 0.4% |
| 6 | 252 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 57 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 98465 | |
| 2 | 9766 | 8.7% |
| 3 | 2270 | 2.0% |
| 4 | 959 | 0.9% |
| 5 | 456 | 0.4% |
| 6 | 252 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 4 | < 0.1% |
| 14 | 6 | |
| 13 | 7 | |
| 12 | 12 |
product_id
Categorical
| Distinct | 32789 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 524 |
|---|---|
| 422879e10f46682990de24d770e7f83d | 486 |
| 99a4788cb24856965c36a24e339b6058 | 482 |
| 389d119b48cf3043d311335e499d9c6b | 391 |
| 368c6c730842d78016ad823897a372db | 388 |
| Other values (32784) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17949 ? |
|---|---|
| Unique (%) | 16.0% |
Sample
| 1st row | f293394c72c9b5fafd7023301fc21fc2 |
|---|---|
| 2nd row | c1488892604e4ba5cff5b4eb4d595400 |
| 3rd row | f3c2d01a84c947b078e32bbef0718962 |
| 4th row | 5a6b04657a4c5ee34285d1e4619a96b4 |
| 5th row | 5a6b04657a4c5ee34285d1e4619a96b4 |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 524 | 0.5% |
| 422879e10f46682990de24d770e7f83d | 486 | 0.4% |
| 99a4788cb24856965c36a24e339b6058 | 482 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 391 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 340 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 320 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 292 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 272 | 0.2% |
| Other values (32779) | 108504 |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 524 | 0.5% |
| 422879e10f46682990de24d770e7f83d | 486 | 0.4% |
| 99a4788cb24856965c36a24e339b6058 | 482 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 391 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 340 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 320 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 292 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 272 | 0.2% |
| Other values (32779) | 108504 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 231245 | 6.4% |
| 9 | 228876 | 6.4% |
| e | 226947 | 6.3% |
| 7 | 226446 | 6.3% |
| 8 | 226313 | 6.3% |
| 4 | 225802 | 6.3% |
| a | 225307 | 6.3% |
| c | 224539 | 6.2% |
| 0 | 224455 | 6.2% |
| 2 | 224352 | 6.2% |
| Other values (6) | 1331622 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2257039 | |
| Lowercase Letter | 1338865 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 231245 | |
| 9 | 228876 | |
| 7 | 226446 | |
| 8 | 226313 | |
| 4 | 225802 | |
| 0 | 224455 | |
| 2 | 224352 | |
| 6 | 223663 | |
| 5 | 223639 | |
| 1 | 222248 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 226947 | |
| a | 225307 | |
| c | 224539 | |
| b | 223178 | |
| d | 221055 | |
| f | 217839 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2257039 | |
| Latin | 1338865 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 231245 | |
| 9 | 228876 | |
| 7 | 226446 | |
| 8 | 226313 | |
| 4 | 225802 | |
| 0 | 224455 | |
| 2 | 224352 | |
| 6 | 223663 | |
| 5 | 223639 | |
| 1 | 222248 |
Latin
| Value | Count | Frequency (%) |
| e | 226947 | |
| a | 225307 | |
| c | 224539 | |
| b | 223178 | |
| d | 221055 | |
| f | 217839 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 231245 | 6.4% |
| 9 | 228876 | 6.4% |
| e | 226947 | 6.3% |
| 7 | 226446 | 6.3% |
| 8 | 226313 | 6.3% |
| 4 | 225802 | 6.3% |
| a | 225307 | 6.3% |
| c | 224539 | 6.2% |
| 0 | 224455 | 6.2% |
| 2 | 224352 | 6.2% |
| Other values (6) | 1331622 |
seller_id
Categorical
| Distinct | 3090 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 6560211a19b47992c3666cc44a7e94c0 | 2020 |
|---|---|
| 4a3ca9315b744ce9f8e9374361493884 | 1984 |
| 1f50f920176fa81dab994f9023523100 | 1932 |
| cc419e0650a3c5ba77189a1882b7556a | 1811 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1568 |
| Other values (3085) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 504 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 1554a68530182680ad5c8b042c3ab563 |
|---|---|
| 2nd row | 1554a68530182680ad5c8b042c3ab563 |
| 3rd row | a425f92c199eb576938df686728acd20 |
| 4th row | ecccfa2bb93b34a3bf033cc5d1dcdc69 |
| 5th row | ecccfa2bb93b34a3bf033cc5d1dcdc69 |
Common Values
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2020 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1984 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1932 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1811 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1568 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1489 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1431 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1367 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1197 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1166 | 1.0% |
| Other values (3080) | 96407 |
Length
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2020 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1984 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1932 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1811 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1568 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1489 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1431 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1367 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1197 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1166 | 1.0% |
| Other values (3080) | 96407 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 243702 | 6.8% |
| c | 237265 | 6.6% |
| 4 | 235579 | 6.6% |
| 6 | 231538 | 6.4% |
| 0 | 230731 | 6.4% |
| a | 229324 | 6.4% |
| b | 228696 | 6.4% |
| 3 | 228492 | 6.4% |
| 9 | 222943 | 6.2% |
| 2 | 222078 | 6.2% |
| Other values (6) | 1285556 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2273806 | |
| Lowercase Letter | 1322098 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 243702 | |
| 4 | 235579 | |
| 6 | 231538 | |
| 0 | 230731 | |
| 3 | 228492 | |
| 9 | 222943 | |
| 2 | 222078 | |
| 8 | 219820 | |
| 5 | 219763 | |
| 7 | 219160 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 237265 | |
| a | 229324 | |
| b | 228696 | |
| e | 211716 | |
| f | 208617 | |
| d | 206480 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2273806 | |
| Latin | 1322098 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 243702 | |
| 4 | 235579 | |
| 6 | 231538 | |
| 0 | 230731 | |
| 3 | 228492 | |
| 9 | 222943 | |
| 2 | 222078 | |
| 8 | 219820 | |
| 5 | 219763 | |
| 7 | 219160 |
Latin
| Value | Count | Frequency (%) |
| c | 237265 | |
| a | 229324 | |
| b | 228696 | |
| e | 211716 | |
| f | 208617 | |
| d | 206480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 243702 | 6.8% |
| c | 237265 | 6.6% |
| 4 | 235579 | 6.6% |
| 6 | 231538 | 6.4% |
| 0 | 230731 | 6.4% |
| a | 229324 | 6.4% |
| b | 228696 | 6.4% |
| 3 | 228492 | 6.4% |
| 9 | 222943 | 6.2% |
| 2 | 222078 | 6.2% |
| Other values (6) | 1285556 |
shipping_limit_date
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 92643 |
|---|---|
| Distinct (%) | 82.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-10-24 13:06:21 | 22 |
|---|---|
| 2017-07-21 18:25:23 | 21 |
| 2018-03-01 02:50:48 | 21 |
| 2017-02-03 21:44:49 | 15 |
| 2017-11-30 10:30:51 | 15 |
| Other values (92638) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2135068 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 78886 ? |
|---|---|
| Unique (%) | 70.2% |
Sample
| 1st row | 2016-10-26 18:25:19 |
|---|---|
| 2nd row | 2016-10-26 18:25:19 |
| 3rd row | 2016-09-19 00:15:34 |
| 4th row | 2016-09-19 23:11:33 |
| 5th row | 2016-09-19 23:11:33 |
Common Values
| Value | Count | Frequency (%) |
| 2017-10-24 13:06:21 | 22 | < 0.1% |
| 2017-07-21 18:25:23 | 21 | < 0.1% |
| 2018-03-01 02:50:48 | 21 | < 0.1% |
| 2017-02-03 21:44:49 | 15 | < 0.1% |
| 2017-11-30 10:30:51 | 15 | < 0.1% |
| 2017-12-21 02:30:41 | 15 | < 0.1% |
| 2018-02-28 11:48:12 | 14 | < 0.1% |
| 2018-06-13 17:30:35 | 13 | < 0.1% |
| 2018-04-19 02:30:52 | 13 | < 0.1% |
| 2018-04-25 22:11:43 | 13 | < 0.1% |
| Other values (92633) | 112210 |
Length
| Value | Count | Frequency (%) |
| 2017-11-30 | 1645 | 0.7% |
| 2017-12-07 | 756 | 0.3% |
| 2018-04-19 | 705 | 0.3% |
| 2018-03-08 | 662 | 0.3% |
| 2018-05-10 | 658 | 0.3% |
| 2018-01-18 | 657 | 0.3% |
| 2018-03-01 | 652 | 0.3% |
| 2018-08-07 | 649 | 0.3% |
| 2018-02-22 | 644 | 0.3% |
| 2018-03-22 | 627 | 0.3% |
| Other values (40510) | 217089 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 360810 | |
| 1 | 345224 | |
| 2 | 275312 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 113258 | 5.3% |
| 112372 | 5.3% | |
| 3 | 108600 | 5.1% |
| 5 | 106431 | 5.0% |
| 7 | 96448 | 4.5% |
| Other values (3) | 167125 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1573208 | |
| Dash Punctuation | 224744 | 10.5% |
| Other Punctuation | 224744 | 10.5% |
| Space Separator | 112372 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 360810 | |
| 1 | 345224 | |
| 2 | 275312 | |
| 8 | 113258 | 7.2% |
| 3 | 108600 | 6.9% |
| 5 | 106431 | 6.8% |
| 7 | 96448 | 6.1% |
| 4 | 75487 | 4.8% |
| 6 | 47066 | 3.0% |
| 9 | 44572 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224744 |
Space Separator
| Value | Count | Frequency (%) |
| 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2135068 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 360810 | |
| 1 | 345224 | |
| 2 | 275312 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 113258 | 5.3% |
| 112372 | 5.3% | |
| 3 | 108600 | 5.1% |
| 5 | 106431 | 5.0% |
| 7 | 96448 | 4.5% |
| Other values (3) | 167125 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2135068 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 360810 | |
| 1 | 345224 | |
| 2 | 275312 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 113258 | 5.3% |
| 112372 | 5.3% | |
| 3 | 108600 | 5.1% |
| 5 | 106431 | 5.0% |
| 7 | 96448 | 4.5% |
| Other values (3) | 167125 |
price
Real number (ℝ)
| Distinct | 5948 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.37896 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 182.15239 |
|---|---|
| Coefficient of variation (CV) | 1.513158 |
| Kurtosis | 109.42271 |
| Mean | 120.37896 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.6696487 |
| Sum | 13527225 |
| Variance | 33179.492 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2472 | 2.2% |
| 69.9 | 2000 | 1.8% |
| 49.9 | 1946 | 1.7% |
| 89.9 | 1545 | 1.4% |
| 99.9 | 1429 | 1.3% |
| 39.9 | 1325 | 1.2% |
| 29.9 | 1319 | 1.2% |
| 79.9 | 1209 | 1.1% |
| 19.9 | 1194 | 1.1% |
| 29.99 | 1171 | 1.0% |
| Other values (5938) | 96762 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 1 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 | |
| 3999 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6976 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.977752 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 382 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.07 |
| median | 16.25 |
| Q3 | 21.15 |
| 95-th percentile | 45.12 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.08 |
Descriptive statistics
| Standard deviation | 15.781421 |
|---|---|
| Coefficient of variation (CV) | 0.78994982 |
| Kurtosis | 60.037405 |
| Mean | 19.977752 |
| Median Absolute Deviation (MAD) | 3.6 |
| Skewness | 5.6452126 |
| Sum | 2244939.9 |
| Variance | 249.05326 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3700 | 3.3% |
| 7.78 | 2255 | 2.0% |
| 14.1 | 1879 | 1.7% |
| 11.85 | 1861 | 1.7% |
| 18.23 | 1572 | 1.4% |
| 7.39 | 1521 | 1.4% |
| 16.11 | 1159 | 1.0% |
| 15.23 | 1005 | 0.9% |
| 8.72 | 923 | 0.8% |
| 16.79 | 869 | 0.8% |
| Other values (6966) | 95628 |
| Value | Count | Frequency (%) |
| 0 | 382 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 4 | < 0.1% |
| 0.06 | 11 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
review_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 97709 |
|---|---|
| Distinct (%) | 87.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 |
|---|---|
| be332150a9c96e68c9565ea53cba2355 | 20 |
| 2e3a6e4930334530774ac3a6f6b62388 | 15 |
| d638a70f2be180ef55395eabb78fd88c | 15 |
| 03129dea7c12fa5878b2e629ccdf2ce6 | 14 |
| Other values (97704) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3595904 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 87398 ? |
|---|---|
| Unique (%) | 77.8% |
Sample
| 1st row | cef1ee03ded4d6272894a2eead6e1328 |
|---|---|
| 2nd row | cef1ee03ded4d6272894a2eead6e1328 |
| 3rd row | a93139d9d1314158c080e3db7e79618b |
| 4th row | 6916ca4502d6d3bfd39818759d55d536 |
| 5th row | 6916ca4502d6d3bfd39818759d55d536 |
Common Values
| Value | Count | Frequency (%) |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| be332150a9c96e68c9565ea53cba2355 | 20 | < 0.1% |
| 2e3a6e4930334530774ac3a6f6b62388 | 15 | < 0.1% |
| d638a70f2be180ef55395eabb78fd88c | 15 | < 0.1% |
| 03129dea7c12fa5878b2e629ccdf2ce6 | 14 | < 0.1% |
| ee4bc8e340e8648a44c2e33fee6b27e4 | 14 | < 0.1% |
| ec530e1eb28f81c279430f63836c4c0c | 13 | < 0.1% |
| e8f500e8052dd5fac20fee5a8c880367 | 13 | < 0.1% |
| d3f6a183fd58d4afd1b44a1bb410d7c2 | 12 | < 0.1% |
| a057d9706ccaec5be597b8048e23f6c6 | 12 | < 0.1% |
| Other values (97699) | 112223 |
Length
| Value | Count | Frequency (%) |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| be332150a9c96e68c9565ea53cba2355 | 20 | < 0.1% |
| 2e3a6e4930334530774ac3a6f6b62388 | 15 | < 0.1% |
| d638a70f2be180ef55395eabb78fd88c | 15 | < 0.1% |
| 03129dea7c12fa5878b2e629ccdf2ce6 | 14 | < 0.1% |
| ee4bc8e340e8648a44c2e33fee6b27e4 | 14 | < 0.1% |
| ec530e1eb28f81c279430f63836c4c0c | 13 | < 0.1% |
| e8f500e8052dd5fac20fee5a8c880367 | 13 | < 0.1% |
| 40b1644940367763775a63267ca6d957 | 12 | < 0.1% |
| f676b4a89abc42681e4cd67dfb2621d5 | 12 | < 0.1% |
| Other values (97699) | 112223 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 225614 | 6.3% |
| 6 | 225546 | 6.3% |
| 5 | 225186 | 6.3% |
| 8 | 225111 | 6.3% |
| b | 224976 | 6.3% |
| f | 224963 | 6.3% |
| 0 | 224784 | 6.3% |
| d | 224761 | 6.3% |
| 2 | 224734 | 6.2% |
| c | 224515 | 6.2% |
| Other values (6) | 1345714 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2246606 | |
| Lowercase Letter | 1349298 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 225546 | |
| 5 | 225186 | |
| 8 | 225111 | |
| 0 | 224784 | |
| 2 | 224734 | |
| 9 | 224417 | |
| 4 | 224305 | |
| 1 | 224298 | |
| 7 | 224240 | |
| 3 | 223985 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 225614 | |
| b | 224976 | |
| f | 224963 | |
| d | 224761 | |
| c | 224515 | |
| e | 224469 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2246606 | |
| Latin | 1349298 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 225546 | |
| 5 | 225186 | |
| 8 | 225111 | |
| 0 | 224784 | |
| 2 | 224734 | |
| 9 | 224417 | |
| 4 | 224305 | |
| 1 | 224298 | |
| 7 | 224240 | |
| 3 | 223985 |
Latin
| Value | Count | Frequency (%) |
| a | 225614 | |
| b | 224976 | |
| f | 224963 | |
| d | 224761 | |
| c | 224515 | |
| e | 224469 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3595904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 225614 | 6.3% |
| 6 | 225546 | 6.3% |
| 5 | 225186 | 6.3% |
| 8 | 225111 | 6.3% |
| b | 224976 | 6.3% |
| f | 224963 | 6.3% |
| 0 | 224784 | 6.3% |
| d | 224761 | 6.3% |
| 2 | 224734 | 6.2% |
| c | 224515 | 6.2% |
| Other values (6) | 1345714 |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 5 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 2 | 3874 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 112372 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 112372 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 112372 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112372 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 63525 | |
| 4 | 21315 | 19.0% |
| 1 | 14235 | 12.7% |
| 3 | 9423 | 8.4% |
| 2 | 3874 | 3.4% |
review_comment_title
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 4497 |
|---|---|
| Distinct (%) | 33.5% |
| Missing | 98938 |
| Missing (%) | 88.0% |
| Memory size | 878.0 KiB |
| Recomendo | 471 |
|---|---|
| recomendo | 392 |
| Bom | 322 |
| super recomendo | 307 |
| Excelente | 281 |
| Other values (4492) |
Length
| Max length | 26 |
|---|---|
| Median length | 20 |
| Mean length | 12.172994 |
| Min length | 1 |
Characters and Unicode
| Total characters | 163532 |
|---|---|
| Distinct characters | 125 |
| Distinct categories | 14 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 3167 ? |
|---|---|
| Unique (%) | 23.6% |
Sample
| 1st row | super recomendado |
|---|---|
| 2nd row | otimo |
| 3rd row | Muito bom. |
| 4th row | A câmera não funcionou |
| 5th row | Cadê meu produto? Acabou! |
Common Values
| Value | Count | Frequency (%) |
| Recomendo | 471 | 0.4% |
| recomendo | 392 | 0.3% |
| Bom | 322 | 0.3% |
| super recomendo | 307 | 0.3% |
| Excelente | 281 | 0.3% |
| Muito bom | 268 | 0.2% |
| Ótimo | 265 | 0.2% |
| Super recomendo | 251 | 0.2% |
| Ótimo | 231 | 0.2% |
| Otimo | 198 | 0.2% |
| Other values (4487) | 10448 | 9.3% |
| (Missing) | 98938 |
Length
| Value | Count | Frequency (%) |
| recomendo | 2389 | 9.3% |
| produto | 1481 | 5.8% |
| bom | 1462 | 5.7% |
| super | 1019 | 4.0% |
| muito | 1006 | 3.9% |
| não | 878 | 3.4% |
| ótimo | 794 | 3.1% |
| excelente | 739 | 2.9% |
| entrega | 674 | 2.6% |
| recebi | 420 | 1.6% |
| Other values (2083) | 14758 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 20356 | 12.4% |
| e | 17478 | 10.7% |
| 14516 | 8.9% | |
| r | 9423 | 5.8% |
| t | 9043 | 5.5% |
| a | 8760 | 5.4% |
| m | 8103 | 5.0% |
| d | 7864 | 4.8% |
| i | 7763 | 4.7% |
| n | 7343 | 4.5% |
| Other values (115) | 52883 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 127012 | |
| Uppercase Letter | 18080 | 11.1% |
| Space Separator | 14516 | 8.9% |
| Other Punctuation | 2600 | 1.6% |
| Decimal Number | 1224 | 0.7% |
| Other Symbol | 47 | < 0.1% |
| Dash Punctuation | 19 | < 0.1% |
| Modifier Symbol | 13 | < 0.1% |
| Math Symbol | 8 | < 0.1% |
| Close Punctuation | 6 | < 0.1% |
| Other values (4) | 7 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 20356 | |
| e | 17478 | |
| r | 9423 | 7.4% |
| t | 9043 | 7.1% |
| a | 8760 | 6.9% |
| m | 8103 | 6.4% |
| d | 7864 | 6.2% |
| i | 7763 | 6.1% |
| n | 7343 | 5.8% |
| c | 5688 | 4.5% |
| Other values (31) | 25191 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2415 | |
| R | 1947 | |
| O | 1608 | 8.9% |
| P | 1529 | 8.5% |
| M | 1397 | 7.7% |
| N | 1138 | 6.3% |
| S | 1012 | 5.6% |
| A | 935 | 5.2% |
| Ó | 915 | 5.1% |
| B | 864 | 4.8% |
| Other values (26) | 4320 |
Other Punctuation
| Value | Count | Frequency (%) |
| ! | 1166 | |
| . | 757 | |
| * | 404 | 15.5% |
| , | 146 | 5.6% |
| ? | 49 | 1.9% |
| / | 39 | 1.5% |
| % | 21 | 0.8% |
| : | 6 | 0.2% |
| " | 3 | 0.1% |
| ; | 3 | 0.1% |
| Other values (4) | 6 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 460 | |
| 1 | 409 | |
| 5 | 81 | 6.6% |
| 2 | 77 | 6.3% |
| 8 | 46 | 3.8% |
| 3 | 40 | 3.3% |
| 4 | 37 | 3.0% |
| 9 | 29 | 2.4% |
| 7 | 24 | 2.0% |
| 6 | 21 | 1.7% |
Other Symbol
| Value | Count | Frequency (%) |
| 👍 | 16 | |
| 😍 | 9 | |
| 👏 | 6 | 12.8% |
| 🌟 | 6 | 12.8% |
| 💥 | 5 | 10.6% |
| 👎 | 1 | 2.1% |
| 🔟 | 1 | 2.1% |
| 🚚 | 1 | 2.1% |
| 🤗 | 1 | 2.1% |
| 😀 | 1 | 2.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 6 | |
| 🏻 | 3 | |
| 🏼 | 2 | 15.4% |
| 🏽 | 2 | 15.4% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7 | |
| = | 1 | 12.5% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 | |
| ] | 1 | 16.7% |
Space Separator
| Value | Count | Frequency (%) |
| 14516 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 145093 | |
| Common | 18439 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 20356 | |
| e | 17478 | |
| r | 9423 | 6.5% |
| t | 9043 | 6.2% |
| a | 8760 | 6.0% |
| m | 8103 | 5.6% |
| d | 7864 | 5.4% |
| i | 7763 | 5.4% |
| n | 7343 | 5.1% |
| c | 5688 | 3.9% |
| Other values (68) | 43272 |
Common
| Value | Count | Frequency (%) |
| 14516 | ||
| ! | 1166 | 6.3% |
| . | 757 | 4.1% |
| 0 | 460 | 2.5% |
| 1 | 409 | 2.2% |
| * | 404 | 2.2% |
| , | 146 | 0.8% |
| 5 | 81 | 0.4% |
| 2 | 77 | 0.4% |
| ? | 49 | 0.3% |
| Other values (37) | 374 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 160022 | |
| None | 3500 | 2.1% |
| Emoticons | 10 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 20356 | |
| e | 17478 | 10.9% |
| 14516 | 9.1% | |
| r | 9423 | 5.9% |
| t | 9043 | 5.7% |
| a | 8760 | 5.5% |
| m | 8103 | 5.1% |
| d | 7864 | 4.9% |
| i | 7763 | 4.9% |
| n | 7343 | 4.6% |
| Other values (75) | 49373 |
None
| Value | Count | Frequency (%) |
| ã | 1063 | |
| Ó | 915 | |
| á | 348 | 9.9% |
| ç | 334 | 9.5% |
| ó | 245 | 7.0% |
| é | 243 | 6.9% |
| Ã | 69 | 2.0% |
| í | 64 | 1.8% |
| ê | 43 | 1.2% |
| É | 28 | 0.8% |
| Other values (28) | 148 | 4.2% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 9 | |
| 😀 | 1 | 10.0% |
review_comment_message
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 35692 |
|---|---|
| Distinct (%) | 74.9% |
| Missing | 64730 |
| Missing (%) | 57.6% |
| Memory size | 878.0 KiB |
| Muito bom | 254 |
|---|---|
| Bom | 200 |
| muito bom | 134 |
| bom | 117 |
| Otimo | 112 |
| Other values (35687) |
Length
| Max length | 208 |
|---|---|
| Median length | 159 |
| Mean length | 70.224844 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3345652 |
|---|---|
| Distinct characters | 208 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 30107 ? |
|---|---|
| Unique (%) | 63.2% |
Sample
| 1st row | 1 mes de atraso na entrega !!! ultima compra q faço |
|---|---|
| 2nd row | 1 mes de atraso na entrega !!! ultima compra q faço |
| 3rd row | Comprei dois produtos desta loja parceira da lannister e nenhum foi entregue, ja faz Mais de dois meses e NEM Dao retorno ... |
| 4th row | nao recebi o produto e nem resposta da empresa |
| 5th row | nao recebi o produto e nem resposta da empresa |
Common Values
| Value | Count | Frequency (%) |
| Muito bom | 254 | 0.2% |
| Bom | 200 | 0.2% |
| muito bom | 134 | 0.1% |
| bom | 117 | 0.1% |
| Otimo | 112 | 0.1% |
| Recomendo | 109 | 0.1% |
| otimo | 102 | 0.1% |
| Ok | 85 | 0.1% |
| Ótimo | 83 | 0.1% |
| Ótimo | 82 | 0.1% |
| Other values (35682) | 46364 | |
| (Missing) | 64730 |
Length
| Value | Count | Frequency (%) |
| o | 21460 | 3.8% |
| produto | 19929 | 3.5% |
| e | 18952 | 3.3% |
| a | 14323 | 2.5% |
| de | 13703 | 2.4% |
| do | 12468 | 2.2% |
| não | 12346 | 2.2% |
| que | 9780 | 1.7% |
| prazo | 9013 | 1.6% |
| muito | 8691 | 1.5% |
| Other values (19532) | 430230 |
Most occurring characters
| Value | Count | Frequency (%) |
| 529480 | ||
| o | 329883 | 9.9% |
| e | 320649 | 9.6% |
| a | 265180 | 7.9% |
| r | 188408 | 5.6% |
| i | 154357 | 4.6% |
| t | 152570 | 4.6% |
| d | 141384 | 4.2% |
| n | 129971 | 3.9% |
| s | 126390 | 3.8% |
| Other values (198) | 1007380 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2526996 | |
| Space Separator | 529480 | 15.8% |
| Uppercase Letter | 160240 | 4.8% |
| Other Punctuation | 91258 | 2.7% |
| Decimal Number | 20963 | 0.6% |
| Control | 13320 | 0.4% |
| Dash Punctuation | 937 | < 0.1% |
| Close Punctuation | 713 | < 0.1% |
| Open Punctuation | 697 | < 0.1% |
| Other Symbol | 675 | < 0.1% |
| Other values (5) | 373 | < 0.1% |
Most frequent character per category
Other Symbol
| Value | Count | Frequency (%) |
| 👏 | 233 | |
| 👍 | 86 | 12.7% |
| 😍 | 71 | 10.5% |
| ° | 27 | 4.0% |
| 😉 | 19 | 2.8% |
| 😆 | 19 | 2.8% |
| 😡 | 18 | 2.7% |
| 😘 | 16 | 2.4% |
| 😁 | 13 | 1.9% |
| 👎 | 13 | 1.9% |
| Other values (54) | 160 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 329883 | |
| e | 320649 | |
| a | 265180 | |
| r | 188408 | 7.5% |
| i | 154357 | 6.1% |
| t | 152570 | 6.0% |
| d | 141384 | 5.6% |
| n | 129971 | 5.1% |
| s | 126390 | 5.0% |
| m | 121057 | 4.8% |
| Other values (40) | 597147 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 18908 | |
| O | 17940 | |
| A | 16562 | |
| P | 11866 | 7.4% |
| R | 11640 | 7.3% |
| C | 9390 | 5.9% |
| M | 9055 | 5.7% |
| N | 9053 | 5.6% |
| S | 7939 | 5.0% |
| T | 7510 | 4.7% |
| Other values (31) | 40377 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 47977 | |
| , | 26579 | |
| ! | 12149 | 13.3% |
| / | 1753 | 1.9% |
| ? | 1550 | 1.7% |
| " | 412 | 0.5% |
| : | 296 | 0.3% |
| ; | 220 | 0.2% |
| % | 176 | 0.2% |
| * | 78 | 0.1% |
| Other values (5) | 68 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4828 | |
| 0 | 4793 | |
| 2 | 3997 | |
| 3 | 1892 | 9.0% |
| 4 | 1325 | 6.3% |
| 5 | 1183 | 5.6% |
| 8 | 910 | 4.3% |
| 6 | 874 | 4.2% |
| 7 | 705 | 3.4% |
| 9 | 456 | 2.2% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 84 | |
| = | 26 | 18.6% |
| | | 12 | 8.6% |
| < | 10 | 7.1% |
| ~ | 3 | 2.1% |
| × | 2 | 1.4% |
| > | 2 | 1.4% |
| ÷ | 1 | 0.7% |
Modifier Symbol
| Value | Count | Frequency (%) |
| 🏻 | 34 | |
| ´ | 26 | |
| 🏼 | 15 | |
| 🏽 | 13 | 12.7% |
| ^ | 8 | 7.8% |
| 🏾 | 4 | 3.9% |
| ` | 2 | 2.0% |
Control
| Value | Count | Frequency (%) |
| 6650 | ||
| 6650 | ||
| 20 | 0.2% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 710 | |
| ] | 3 | 0.4% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 691 | |
| [ | 6 | 0.9% |
Other Letter
| Value | Count | Frequency (%) |
| º | 26 | |
| ª | 19 |
Space Separator
| Value | Count | Frequency (%) |
| 529480 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 937 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 78 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2687281 | |
| Common | 658371 | 19.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 529480 | ||
| . | 47977 | 7.3% |
| , | 26579 | 4.0% |
| ! | 12149 | 1.8% |
| 6650 | 1.0% | |
| 6650 | 1.0% | |
| 1 | 4828 | 0.7% |
| 0 | 4793 | 0.7% |
| 2 | 3997 | 0.6% |
| 3 | 1892 | 0.3% |
| Other values (105) | 13376 | 2.0% |
Latin
| Value | Count | Frequency (%) |
| o | 329883 | |
| e | 320649 | |
| a | 265180 | 9.9% |
| r | 188408 | 7.0% |
| i | 154357 | 5.7% |
| t | 152570 | 5.7% |
| d | 141384 | 5.3% |
| n | 129971 | 4.8% |
| s | 126390 | 4.7% |
| m | 121057 | 4.5% |
| Other values (83) | 757432 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3285002 | |
| None | 60415 | 1.8% |
| Emoticons | 235 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 529480 | ||
| o | 329883 | 10.0% |
| e | 320649 | 9.8% |
| a | 265180 | 8.1% |
| r | 188408 | 5.7% |
| i | 154357 | 4.7% |
| t | 152570 | 4.6% |
| d | 141384 | 4.3% |
| n | 129971 | 4.0% |
| s | 126390 | 3.8% |
| Other values (85) | 946730 |
None
| Value | Count | Frequency (%) |
| ã | 17772 | |
| é | 10851 | |
| á | 8676 | |
| ç | 7132 | |
| ó | 5980 | 9.9% |
| ê | 1847 | 3.1% |
| í | 1671 | 2.8% |
| Ó | 1490 | 2.5% |
| õ | 901 | 1.5% |
| ú | 850 | 1.4% |
| Other values (73) | 3245 | 5.4% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 71 | |
| 😉 | 19 | 8.1% |
| 😆 | 19 | 8.1% |
| 😡 | 18 | 7.7% |
| 😘 | 16 | 6.8% |
| 😁 | 13 | 5.5% |
| 😊 | 12 | 5.1% |
| 😀 | 8 | 3.4% |
| 😩 | 7 | 3.0% |
| 😃 | 6 | 2.6% |
| Other values (20) | 46 |
review_creation_date
Categorical
| Distinct | 633 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-12-19 00:00:00 | 516 |
|---|---|
| 2018-05-15 00:00:00 | 507 |
| 2018-05-19 00:00:00 | 497 |
| 2018-08-28 00:00:00 | 495 |
| 2017-12-20 00:00:00 | 489 |
| Other values (628) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2135068 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2016-10-22 00:00:00 |
|---|---|
| 2nd row | 2016-10-22 00:00:00 |
| 3rd row | 2016-10-29 00:00:00 |
| 4th row | 2016-10-06 00:00:00 |
| 5th row | 2016-10-06 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-19 00:00:00 | 516 | 0.5% |
| 2018-05-15 00:00:00 | 507 | 0.5% |
| 2018-05-19 00:00:00 | 497 | 0.4% |
| 2018-08-28 00:00:00 | 495 | 0.4% |
| 2017-12-20 00:00:00 | 489 | 0.4% |
| 2018-05-22 00:00:00 | 487 | 0.4% |
| 2018-03-29 00:00:00 | 486 | 0.4% |
| 2018-08-14 00:00:00 | 472 | 0.4% |
| 2018-04-12 00:00:00 | 467 | 0.4% |
| 2018-05-04 00:00:00 | 467 | 0.4% |
| Other values (623) | 107489 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 112281 | |
| 2017-12-19 | 516 | 0.2% |
| 2018-05-15 | 507 | 0.2% |
| 2018-05-19 | 497 | 0.2% |
| 2018-08-28 | 495 | 0.2% |
| 2017-12-20 | 489 | 0.2% |
| 2018-05-22 | 487 | 0.2% |
| 2018-03-29 | 486 | 0.2% |
| 2018-08-14 | 472 | 0.2% |
| 2018-04-12 | 467 | 0.2% |
| Other values (625) | 108047 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 926201 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 195042 | 9.1% |
| 2 | 179503 | 8.4% |
| 112372 | 5.3% | |
| 8 | 90400 | 4.2% |
| 7 | 70105 | 3.3% |
| 3 | 27600 | 1.3% |
| 5 | 23953 | 1.1% |
| Other values (3) | 60404 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1573208 | |
| Dash Punctuation | 224744 | 10.5% |
| Other Punctuation | 224744 | 10.5% |
| Space Separator | 112372 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 926201 | |
| 1 | 195042 | 12.4% |
| 2 | 179503 | 11.4% |
| 8 | 90400 | 5.7% |
| 7 | 70105 | 4.5% |
| 3 | 27600 | 1.8% |
| 5 | 23953 | 1.5% |
| 4 | 22663 | 1.4% |
| 6 | 22279 | 1.4% |
| 9 | 15462 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224744 |
Space Separator
| Value | Count | Frequency (%) |
| 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2135068 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 926201 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 195042 | 9.1% |
| 2 | 179503 | 8.4% |
| 112372 | 5.3% | |
| 8 | 90400 | 4.2% |
| 7 | 70105 | 3.3% |
| 3 | 27600 | 1.3% |
| 5 | 23953 | 1.1% |
| Other values (3) | 60404 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2135068 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 926201 | |
| - | 224744 | 10.5% |
| : | 224744 | 10.5% |
| 1 | 195042 | 9.1% |
| 2 | 179503 | 8.4% |
| 112372 | 5.3% | |
| 8 | 90400 | 4.2% |
| 7 | 70105 | 3.3% |
| 3 | 27600 | 1.3% |
| 5 | 23953 | 1.1% |
| Other values (3) | 60404 | 2.8% |
review_answer_timestamp
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 97547 |
|---|---|
| Distinct (%) | 86.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-07-30 14:19:07 | 21 |
|---|---|
| 2018-03-12 12:46:07 | 20 |
| 2017-02-16 17:14:41 | 15 |
| 2017-12-19 14:14:16 | 15 |
| 2017-12-31 12:08:24 | 14 |
| Other values (97542) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2135068 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 87111 ? |
|---|---|
| Unique (%) | 77.5% |
Sample
| 1st row | 2016-11-15 16:00:34 |
|---|---|
| 2nd row | 2016-11-15 16:00:34 |
| 3rd row | 2016-10-30 01:47:48 |
| 4th row | 2016-10-07 18:32:28 |
| 5th row | 2016-10-07 18:32:28 |
Common Values
| Value | Count | Frequency (%) |
| 2017-07-30 14:19:07 | 21 | < 0.1% |
| 2018-03-12 12:46:07 | 20 | < 0.1% |
| 2017-02-16 17:14:41 | 15 | < 0.1% |
| 2017-12-19 14:14:16 | 15 | < 0.1% |
| 2017-12-31 12:08:24 | 14 | < 0.1% |
| 2018-03-03 00:44:54 | 14 | < 0.1% |
| 2017-10-24 08:44:02 | 13 | < 0.1% |
| 2018-04-26 20:37:35 | 13 | < 0.1% |
| 2018-01-26 12:22:14 | 12 | < 0.1% |
| 2017-10-19 22:55:25 | 12 | < 0.1% |
| Other values (97537) | 112223 |
Length
| Value | Count | Frequency (%) |
| 2018-05-20 | 761 | 0.3% |
| 2018-05-21 | 673 | 0.3% |
| 2018-05-10 | 565 | 0.3% |
| 2017-12-20 | 438 | 0.2% |
| 2018-04-13 | 428 | 0.2% |
| 2017-12-13 | 415 | 0.2% |
| 2018-05-11 | 406 | 0.2% |
| 2018-08-24 | 396 | 0.2% |
| 2017-12-21 | 394 | 0.2% |
| 2018-08-31 | 390 | 0.2% |
| Other values (53772) | 219878 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 359552 | |
| 1 | 333159 | |
| 2 | 284979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 118619 | 5.6% |
| 112372 | 5.3% | |
| 3 | 104570 | 4.9% |
| 7 | 96566 | 4.5% |
| 5 | 88993 | 4.2% |
| Other values (3) | 186770 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1573208 | |
| Dash Punctuation | 224744 | 10.5% |
| Other Punctuation | 224744 | 10.5% |
| Space Separator | 112372 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 359552 | |
| 1 | 333159 | |
| 2 | 284979 | |
| 8 | 118619 | 7.5% |
| 3 | 104570 | 6.6% |
| 7 | 96566 | 6.1% |
| 5 | 88993 | 5.7% |
| 4 | 88786 | 5.6% |
| 6 | 50704 | 3.2% |
| 9 | 47280 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 224744 |
Space Separator
| Value | Count | Frequency (%) |
| 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2135068 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 359552 | |
| 1 | 333159 | |
| 2 | 284979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 118619 | 5.6% |
| 112372 | 5.3% | |
| 3 | 104570 | 4.9% |
| 7 | 96566 | 4.5% |
| 5 | 88993 | 4.2% |
| Other values (3) | 186770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2135068 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 359552 | |
| 1 | 333159 | |
| 2 | 284979 | |
| - | 224744 | |
| : | 224744 | |
| 8 | 118619 | 5.6% |
| 112372 | 5.3% | |
| 3 | 104570 | 4.9% |
| 7 | 96566 | 4.5% |
| 5 | 88993 | 4.2% |
| Other values (3) | 186770 |
product_category_name
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1598 |
| Missing (%) | 1.4% |
| Memory size | 878.0 KiB |
| cama_mesa_banho | |
|---|---|
| beleza_saude | |
| esporte_lazer | |
| moveis_decoracao | |
| informatica_acessorios | |
| Other values (68) |
Length
| Max length | 46 |
|---|---|
| Median length | 32 |
| Mean length | 14.867415 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1646923 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | moveis_decoracao |
|---|---|
| 2nd row | moveis_decoracao |
| 3rd row | telefonia |
| 4th row | beleza_saude |
| 5th row | beleza_saude |
Common Values
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11137 | 9.9% |
| beleza_saude | 9645 | 8.6% |
| esporte_lazer | 8640 | 7.7% |
| moveis_decoracao | 8331 | 7.4% |
| informatica_acessorios | 7849 | 7.0% |
| utilidades_domesticas | 6943 | 6.2% |
| relogios_presentes | 5950 | 5.3% |
| telefonia | 4517 | 4.0% |
| ferramentas_jardim | 4329 | 3.9% |
| automotivo | 4213 | 3.7% |
| Other values (63) | 39220 |
Length
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11137 | 10.1% |
| beleza_saude | 9645 | 8.7% |
| esporte_lazer | 8640 | 7.8% |
| moveis_decoracao | 8331 | 7.5% |
| informatica_acessorios | 7849 | 7.1% |
| utilidades_domesticas | 6943 | 6.3% |
| relogios_presentes | 5950 | 5.4% |
| telefonia | 4517 | 4.1% |
| ferramentas_jardim | 4329 | 3.9% |
| automotivo | 4213 | 3.8% |
| Other values (63) | 39220 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 200532 | |
| a | 197630 | |
| s | 164170 | |
| o | 163030 | |
| i | 109507 | 6.6% |
| r | 106270 | 6.5% |
| _ | 104446 | 6.3% |
| t | 79354 | 4.8% |
| c | 78054 | 4.7% |
| m | 74127 | 4.5% |
| Other values (18) | 369803 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1542212 | |
| Connector Punctuation | 104446 | 6.3% |
| Decimal Number | 265 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 200532 | |
| a | 197630 | |
| s | 164170 | |
| o | 163030 | |
| i | 109507 | 7.1% |
| r | 106270 | 6.9% |
| t | 79354 | 5.1% |
| c | 78054 | 5.1% |
| m | 74127 | 4.8% |
| n | 56168 | 3.6% |
| Other values (16) | 313370 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 104446 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 265 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1542212 | |
| Common | 104711 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 200532 | |
| a | 197630 | |
| s | 164170 | |
| o | 163030 | |
| i | 109507 | 7.1% |
| r | 106270 | 6.9% |
| t | 79354 | 5.1% |
| c | 78054 | 5.1% |
| m | 74127 | 4.8% |
| n | 56168 | 3.6% |
| Other values (16) | 313370 |
Common
| Value | Count | Frequency (%) |
| _ | 104446 | |
| 2 | 265 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1646923 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 200532 | |
| a | 197630 | |
| s | 164170 | |
| o | 163030 | |
| i | 109507 | 6.6% |
| r | 106270 | 6.5% |
| _ | 104446 | 6.3% |
| t | 79354 | 4.8% |
| c | 78054 | 4.7% |
| m | 74127 | 4.5% |
| Other values (18) | 369803 |
product_name_lenght
Real number (ℝ)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1598 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.777583 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.025179 |
|---|---|
| Coefficient of variation (CV) | 0.20552841 |
| Kurtosis | 0.15452858 |
| Mean | 48.777583 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90730409 |
| Sum | 5403288 |
| Variance | 100.50422 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8302 | 7.4% |
| 60 | 7692 | 6.8% |
| 56 | 6512 | 5.8% |
| 58 | 6418 | 5.7% |
| 57 | 5985 | 5.3% |
| 55 | 5539 | 4.9% |
| 54 | 5245 | 4.7% |
| 53 | 4160 | 3.7% |
| 52 | 4144 | 3.7% |
| 49 | 3561 | 3.2% |
| Other values (56) | 53216 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 13 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 10 | < 0.1% |
| 12 | 37 | |
| 13 | 26 | |
| 14 | 45 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 163 | 0.1% |
| 63 | 1253 | |
| 62 | 153 | 0.1% |
| 61 | 233 | 0.2% |
product_description_lenght
Real number (ℝ)
| Distinct | 2958 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 1598 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 786.79393 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 161 |
| Q1 | 348 |
| median | 601 |
| Q3 | 985 |
| 95-th percentile | 2120 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 651.6095 |
|---|---|
| Coefficient of variation (CV) | 0.82818318 |
| Kurtosis | 4.9090181 |
| Mean | 786.79393 |
| Median Absolute Deviation (MAD) | 295 |
| Skewness | 2.0066937 |
| Sum | 87156311 |
| Variance | 424594.94 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 688 | 0.6% |
| 1893 | 633 | 0.6% |
| 348 | 619 | 0.6% |
| 903 | 577 | 0.5% |
| 492 | 577 | 0.5% |
| 245 | 541 | 0.5% |
| 366 | 521 | 0.5% |
| 236 | 486 | 0.4% |
| 340 | 465 | 0.4% |
| 919 | 421 | 0.4% |
| Other values (2948) | 105246 | |
| (Missing) | 1598 | 1.4% |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 6 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 3 | < 0.1% |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 5 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1598 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2071244 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7197871 |
|---|---|
| Coefficient of variation (CV) | 0.7791981 |
| Kurtosis | 4.865013 |
| Mean | 2.2071244 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9127487 |
| Sum | 244492 |
| Variance | 2.9576678 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 55943 | |
| 2 | 21947 | 19.5% |
| 3 | 12339 | 11.0% |
| 4 | 8383 | 7.5% |
| 5 | 5344 | 4.8% |
| 6 | 3758 | 3.3% |
| 7 | 1498 | 1.3% |
| 8 | 726 | 0.6% |
| 10 | 342 | 0.3% |
| 9 | 304 | 0.3% |
| Other values (9) | 190 | 0.2% |
| (Missing) | 1598 | 1.4% |
| Value | Count | Frequency (%) |
| 1 | 55943 | |
| 2 | 21947 | 19.5% |
| 3 | 12339 | 11.0% |
| 4 | 8383 | 7.5% |
| 5 | 5344 | 4.8% |
| 6 | 3758 | 3.3% |
| 7 | 1498 | 1.3% |
| 8 | 726 | 0.6% |
| 9 | 304 | 0.3% |
| 10 | 342 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 53 | < 0.1% |
| 11 | 71 | 0.1% |
| 10 | 342 |
product_weight_g
Real number (ℝ)
| Distinct | 2200 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2090.6109 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9750 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3748.6081 |
|---|---|
| Coefficient of variation (CV) | 1.7930683 |
| Kurtosis | 16.263327 |
| Mean | 2090.6109 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5994489 |
| Sum | 2.348885 × 108 |
| Variance | 14052063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 6757 | 6.0% |
| 150 | 5250 | 4.7% |
| 250 | 4530 | 4.0% |
| 300 | 4237 | 3.8% |
| 400 | 3629 | 3.2% |
| 100 | 3511 | 3.1% |
| 350 | 3167 | 2.8% |
| 500 | 2693 | 2.4% |
| 600 | 2689 | 2.4% |
| 700 | 2035 | 1.8% |
| Other values (2190) | 73856 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 948 | |
| 53 | 2 | < 0.1% |
| 54 | 1 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 278 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.152198 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.139323 |
|---|---|
| Coefficient of variation (CV) | 0.53526191 |
| Kurtosis | 3.7356739 |
| Mean | 30.152198 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7587665 |
| Sum | 3387720 |
| Variance | 260.47774 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 17523 | 15.6% |
| 20 | 10522 | 9.4% |
| 30 | 7541 | 6.7% |
| 17 | 5946 | 5.3% |
| 18 | 5720 | 5.1% |
| 25 | 4675 | 4.2% |
| 19 | 4662 | 4.1% |
| 40 | 4098 | 3.6% |
| 22 | 3831 | 3.4% |
| 50 | 2951 | 2.6% |
| Other values (89) | 44885 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 95 | 0.1% |
| 12 | 40 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 134 | 0.1% |
| 15 | 201 | 0.2% |
| 16 | 17523 |
| Value | Count | Frequency (%) |
| 105 | 326 | |
| 104 | 28 | < 0.1% |
| 103 | 45 | < 0.1% |
| 102 | 59 | 0.1% |
| 101 | 107 | 0.1% |
| 100 | 379 | |
| 99 | 35 | < 0.1% |
| 98 | 47 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.576811 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.437792 |
|---|---|
| Coefficient of variation (CV) | 0.81063796 |
| Kurtosis | 7.3883945 |
| Mean | 16.576811 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2558193 |
| Sum | 1862471 |
| Variance | 180.57426 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 9820 | 8.7% |
| 15 | 6563 | 5.8% |
| 20 | 6533 | 5.8% |
| 12 | 6245 | 5.6% |
| 11 | 6132 | 5.5% |
| 2 | 4996 | 4.4% |
| 8 | 4670 | 4.2% |
| 4 | 4659 | 4.1% |
| 5 | 4558 | 4.1% |
| 16 | 4549 | 4.0% |
| Other values (92) | 53629 |
| Value | Count | Frequency (%) |
| 2 | 4996 | |
| 3 | 2701 | 2.4% |
| 4 | 4659 | |
| 5 | 4558 | |
| 6 | 3394 | 3.0% |
| 7 | 4184 | |
| 8 | 4670 | |
| 9 | 3219 | 2.9% |
| 10 | 9820 | |
| 11 | 6132 |
| Value | Count | Frequency (%) |
| 105 | 133 | |
| 104 | 12 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 41 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.00121 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.707552 |
|---|---|
| Coefficient of variation (CV) | 0.50899722 |
| Kurtosis | 4.6498388 |
| Mean | 23.00121 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.7221613 |
| Sum | 2584278 |
| Variance | 137.06678 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12047 | 10.7% |
| 11 | 10632 | 9.5% |
| 15 | 8935 | 8.0% |
| 16 | 8428 | 7.5% |
| 30 | 7601 | 6.8% |
| 12 | 5454 | 4.9% |
| 13 | 5254 | 4.7% |
| 14 | 4594 | 4.1% |
| 18 | 4065 | 3.6% |
| 40 | 3877 | 3.5% |
| Other values (85) | 41467 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 28 | < 0.1% |
| 9 | 50 | < 0.1% |
| 10 | 82 | 0.1% |
| 11 | 10632 | |
| 12 | 5454 | |
| 13 | 5254 | |
| 14 | 4594 | |
| 15 | 8935 |
| Value | Count | Frequency (%) |
| 118 | 7 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 42 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
date_achat
Categorical
| Distinct | 616 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2017-11-24 | 1366 |
|---|---|
| 2017-11-25 | 580 |
| 2017-11-27 | 480 |
| 2017-11-26 | 452 |
| 2018-08-06 | 430 |
| Other values (611) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1123720 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2016-09-04 |
|---|---|
| 2nd row | 2016-09-04 |
| 3rd row | 2016-09-05 |
| 4th row | 2016-09-15 |
| 5th row | 2016-09-15 |
Common Values
| Value | Count | Frequency (%) |
| 2017-11-24 | 1366 | 1.2% |
| 2017-11-25 | 580 | 0.5% |
| 2017-11-27 | 480 | 0.4% |
| 2017-11-26 | 452 | 0.4% |
| 2018-08-06 | 430 | 0.4% |
| 2018-08-07 | 429 | 0.4% |
| 2017-11-28 | 428 | 0.4% |
| 2018-05-15 | 420 | 0.4% |
| 2018-05-07 | 417 | 0.4% |
| 2018-05-14 | 412 | 0.4% |
| Other values (606) | 106958 |
Length
| Value | Count | Frequency (%) |
| 2017-11-24 | 1366 | 1.2% |
| 2017-11-25 | 580 | 0.5% |
| 2017-11-27 | 480 | 0.4% |
| 2017-11-26 | 452 | 0.4% |
| 2018-08-06 | 430 | 0.4% |
| 2018-08-07 | 429 | 0.4% |
| 2017-11-28 | 428 | 0.4% |
| 2018-05-15 | 420 | 0.4% |
| 2018-05-07 | 417 | 0.4% |
| 2018-05-14 | 412 | 0.4% |
| Other values (606) | 106958 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 253499 | |
| - | 224744 | |
| 1 | 201038 | |
| 2 | 175507 | |
| 8 | 84365 | 7.5% |
| 7 | 73373 | 6.5% |
| 3 | 26869 | 2.4% |
| 5 | 23676 | 2.1% |
| 6 | 22760 | 2.0% |
| 4 | 22631 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 898976 | |
| Dash Punctuation | 224744 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 253499 | |
| 1 | 201038 | |
| 2 | 175507 | |
| 8 | 84365 | 9.4% |
| 7 | 73373 | 8.2% |
| 3 | 26869 | 3.0% |
| 5 | 23676 | 2.6% |
| 6 | 22760 | 2.5% |
| 4 | 22631 | 2.5% |
| 9 | 15258 | 1.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1123720 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 253499 | |
| - | 224744 | |
| 1 | 201038 | |
| 2 | 175507 | |
| 8 | 84365 | 7.5% |
| 7 | 73373 | 6.5% |
| 3 | 26869 | 2.4% |
| 5 | 23676 | 2.1% |
| 6 | 22760 | 2.0% |
| 4 | 22631 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1123720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 253499 | |
| - | 224744 | |
| 1 | 201038 | |
| 2 | 175507 | |
| 8 | 84365 | 7.5% |
| 7 | 73373 | 6.5% |
| 3 | 26869 | 2.4% |
| 5 | 23676 | 2.1% |
| 6 | 22760 | 2.0% |
| 4 | 22631 | 2.0% |
date_initial
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2016-09-04 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1123720 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016-09-04 |
|---|---|
| 2nd row | 2016-09-04 |
| 3rd row | 2016-09-04 |
| 4th row | 2016-09-04 |
| 5th row | 2016-09-04 |
Common Values
| Value | Count | Frequency (%) |
| 2016-09-04 | 112372 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016-09-04 | 112372 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 337116 | |
| - | 224744 | |
| 2 | 112372 | 10.0% |
| 1 | 112372 | 10.0% |
| 6 | 112372 | 10.0% |
| 9 | 112372 | 10.0% |
| 4 | 112372 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 898976 | |
| Dash Punctuation | 224744 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 337116 | |
| 2 | 112372 | 12.5% |
| 1 | 112372 | 12.5% |
| 6 | 112372 | 12.5% |
| 9 | 112372 | 12.5% |
| 4 | 112372 | 12.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 224744 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1123720 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 337116 | |
| - | 224744 | |
| 2 | 112372 | 10.0% |
| 1 | 112372 | 10.0% |
| 6 | 112372 | 10.0% |
| 9 | 112372 | 10.0% |
| 4 | 112372 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1123720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 337116 | |
| - | 224744 | |
| 2 | 112372 | 10.0% |
| 1 | 112372 | 10.0% |
| 6 | 112372 | 10.0% |
| 9 | 112372 | 10.0% |
| 4 | 112372 | 10.0% |
diff_days
Real number (ℝ)
| Distinct | 616 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 483.15701 |
| Minimum | 0 |
|---|---|
| Maximum | 729 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 201 |
| Q1 | 374 |
| median | 502 |
| Q3 | 607 |
| 95-th percentile | 700 |
| Maximum | 729 |
| Range | 729 |
| Interquartile range (IQR) | 233 |
Descriptive statistics
| Standard deviation | 153.1612 |
|---|---|
| Coefficient of variation (CV) | 0.31700089 |
| Kurtosis | -0.66009543 |
| Mean | 483.15701 |
| Median Absolute Deviation (MAD) | 113 |
| Skewness | -0.43714988 |
| Sum | 54293320 |
| Variance | 23458.354 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 446 | 1366 | 1.2% |
| 447 | 580 | 0.5% |
| 449 | 480 | 0.4% |
| 448 | 452 | 0.4% |
| 701 | 430 | 0.4% |
| 702 | 429 | 0.4% |
| 450 | 428 | 0.4% |
| 618 | 420 | 0.4% |
| 610 | 417 | 0.4% |
| 617 | 412 | 0.4% |
| Other values (606) | 106958 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 1 | < 0.1% |
| 11 | 3 | < 0.1% |
| 28 | 1 | < 0.1% |
| 29 | 8 | < 0.1% |
| 30 | 69 | |
| 31 | 54 | |
| 32 | 58 | |
| 33 | 49 | |
| 34 | 45 |
| Value | Count | Frequency (%) |
| 729 | 1 | < 0.1% |
| 724 | 16 | < 0.1% |
| 723 | 45 | < 0.1% |
| 722 | 70 | 0.1% |
| 721 | 82 | 0.1% |
| 720 | 75 | 0.1% |
| 719 | 117 | |
| 718 | 161 | |
| 717 | 216 | |
| 716 | 258 |
dummy
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 112372 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 112372 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 112372 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 112372 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 112372 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 112372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 112372 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 112372 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112372 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 112372 |
score_freq
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 1 | |
|---|---|
| 2 | 1496 |
| 3 | 210 |
| 5 | 63 |
| 4 | 58 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 112372 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 112372 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 112372 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112372 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 110545 | |
| 2 | 1496 | 1.3% |
| 3 | 210 | 0.2% |
| 5 | 63 | 0.1% |
| 4 | 58 | 0.1% |
score_rec
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 2 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 5 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 112372 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 112372 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 112372 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112372 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 22735 | |
| 4 | 22506 | |
| 1 | 22477 | |
| 3 | 22453 | |
| 5 | 22201 |
score_montant
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 878.0 KiB |
| 5 | |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 112372 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 4 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 112372 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 112372 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112372 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 25984 | |
| 4 | 22818 | |
| 3 | 21977 | |
| 2 | 21117 | |
| 1 | 20476 |
score_rfm
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.1270601 |
| Minimum | 3 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 878.0 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 6 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 10 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.0384348 |
|---|---|
| Coefficient of variation (CV) | 0.28601342 |
| Kurtosis | -0.6332774 |
| Mean | 7.1270601 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.018720136 |
| Sum | 800882 |
| Variance | 4.1552165 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 22132 | |
| 8 | 18487 | |
| 6 | 16574 | |
| 9 | 14048 | |
| 5 | 13036 | |
| 10 | 9994 | |
| 4 | 8305 | 7.4% |
| 11 | 5119 | 4.6% |
| 3 | 4292 | 3.8% |
| 12 | 344 | 0.3% |
| Value | Count | Frequency (%) |
| 3 | 4292 | 3.8% |
| 4 | 8305 | 7.4% |
| 5 | 13036 | |
| 6 | 16574 | |
| 7 | 22132 | |
| 8 | 18487 | |
| 9 | 14048 | |
| 10 | 9994 | |
| 11 | 5119 | 4.6% |
| 12 | 344 | 0.3% |
| Value | Count | Frequency (%) |
| 13 | 41 | < 0.1% |
| 12 | 344 | 0.3% |
| 11 | 5119 | 4.6% |
| 10 | 9994 | |
| 9 | 14048 | |
| 8 | 18487 | |
| 7 | 22132 | |
| 6 | 16574 | |
| 5 | 13036 | |
| 4 | 8305 | 7.4% |
| Unnamed: 0 | customer_zip_code_prefix | order_item_id | price | freight_value | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | diff_days | score_rfm | customer_state | order_status | review_score | product_category_name | score_freq | score_rec | score_montant | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | -0.062 | 0.001 | 0.009 | 0.045 | 0.030 | 0.057 | -0.011 | -0.055 | -0.079 | -0.010 | -0.060 | 1.000 | 0.679 | 0.028 | 0.033 | 0.056 | 0.098 | 0.031 | 0.991 | 0.023 |
| customer_zip_code_prefix | -0.062 | 1.000 | -0.009 | 0.071 | 0.469 | 0.016 | 0.029 | 0.027 | 0.028 | 0.013 | 0.019 | 0.001 | -0.062 | 0.003 | 0.896 | 0.023 | 0.042 | 0.051 | 0.030 | 0.034 | 0.041 |
| order_item_id | 0.001 | -0.009 | 1.000 | -0.116 | -0.055 | -0.020 | -0.032 | -0.066 | 0.001 | 0.007 | 0.018 | -0.004 | 0.001 | 0.164 | 0.000 | 0.004 | 0.042 | 0.029 | 0.465 | 0.011 | 0.071 |
| price | 0.009 | 0.071 | -0.116 | 1.000 | 0.434 | 0.040 | 0.209 | 0.028 | 0.514 | 0.266 | 0.326 | 0.271 | 0.009 | 0.604 | 0.019 | 0.013 | 0.011 | 0.113 | 0.000 | 0.012 | 0.121 |
| freight_value | 0.045 | 0.469 | -0.055 | 0.434 | 1.000 | 0.034 | 0.117 | 0.010 | 0.446 | 0.283 | 0.282 | 0.274 | 0.045 | 0.292 | 0.085 | 0.014 | 0.013 | 0.093 | 0.020 | 0.034 | 0.129 |
| product_name_lenght | 0.030 | 0.016 | -0.020 | 0.040 | 0.034 | 1.000 | 0.074 | 0.163 | 0.077 | 0.062 | -0.055 | 0.068 | 0.030 | 0.031 | 0.012 | 0.019 | 0.013 | 0.132 | 0.026 | 0.058 | 0.043 |
| product_description_lenght | 0.057 | 0.029 | -0.032 | 0.209 | 0.117 | 0.074 | 1.000 | 0.111 | 0.095 | -0.019 | 0.132 | -0.079 | 0.057 | 0.156 | 0.022 | 0.008 | 0.013 | 0.203 | 0.026 | 0.043 | 0.096 |
| product_photos_qty | -0.011 | 0.027 | -0.066 | 0.028 | 0.010 | 0.163 | 0.111 | 1.000 | 0.005 | 0.007 | -0.081 | -0.013 | -0.011 | -0.021 | 0.014 | 0.013 | 0.015 | 0.151 | 0.019 | 0.029 | 0.026 |
| product_weight_g | -0.055 | 0.028 | 0.001 | 0.514 | 0.446 | 0.077 | 0.095 | 0.005 | 1.000 | 0.618 | 0.531 | 0.620 | -0.055 | 0.292 | 0.015 | 0.006 | 0.020 | 0.199 | 0.019 | 0.022 | 0.171 |
| product_length_cm | -0.079 | 0.013 | 0.007 | 0.266 | 0.283 | 0.062 | -0.019 | 0.007 | 0.618 | 1.000 | 0.248 | 0.631 | -0.079 | 0.117 | 0.013 | 0.009 | 0.018 | 0.259 | 0.023 | 0.046 | 0.140 |
| product_height_cm | -0.010 | 0.019 | 0.018 | 0.326 | 0.282 | -0.055 | 0.132 | -0.081 | 0.531 | 0.248 | 1.000 | 0.340 | -0.010 | 0.210 | 0.016 | 0.014 | 0.018 | 0.278 | 0.037 | 0.035 | 0.149 |
| product_width_cm | -0.060 | 0.001 | -0.004 | 0.271 | 0.274 | 0.068 | -0.079 | -0.013 | 0.620 | 0.631 | 0.340 | 1.000 | -0.060 | 0.129 | 0.012 | 0.003 | 0.013 | 0.295 | 0.029 | 0.041 | 0.141 |
| diff_days | 1.000 | -0.062 | 0.001 | 0.009 | 0.045 | 0.030 | 0.057 | -0.011 | -0.055 | -0.079 | -0.010 | -0.060 | 1.000 | 0.679 | 0.029 | 0.067 | 0.059 | 0.098 | 0.031 | 0.807 | 0.024 |
| score_rfm | 0.679 | 0.003 | 0.164 | 0.604 | 0.292 | 0.031 | 0.156 | -0.021 | 0.292 | 0.117 | 0.210 | 0.129 | 0.679 | 1.000 | 0.024 | 0.012 | 0.038 | 0.114 | 0.335 | 0.426 | 0.430 |
| customer_state | 0.028 | 0.896 | 0.000 | 0.019 | 0.085 | 0.012 | 0.022 | 0.014 | 0.015 | 0.013 | 0.016 | 0.012 | 0.029 | 0.024 | 1.000 | 0.025 | 0.049 | 0.034 | 0.034 | 0.036 | 0.041 |
| order_status | 0.033 | 0.023 | 0.004 | 0.013 | 0.014 | 0.019 | 0.008 | 0.013 | 0.006 | 0.009 | 0.014 | 0.003 | 0.067 | 0.012 | 0.025 | 1.000 | 0.132 | 0.029 | 0.007 | 0.030 | 0.014 |
| review_score | 0.056 | 0.042 | 0.042 | 0.011 | 0.013 | 0.013 | 0.013 | 0.015 | 0.020 | 0.018 | 0.018 | 0.013 | 0.059 | 0.038 | 0.049 | 0.132 | 1.000 | 0.054 | 0.051 | 0.043 | 0.041 |
| product_category_name | 0.098 | 0.051 | 0.029 | 0.113 | 0.093 | 0.132 | 0.203 | 0.151 | 0.199 | 0.259 | 0.278 | 0.295 | 0.098 | 0.114 | 0.034 | 0.029 | 0.054 | 1.000 | 0.075 | 0.127 | 0.219 |
| score_freq | 0.031 | 0.030 | 0.465 | 0.000 | 0.020 | 0.026 | 0.026 | 0.019 | 0.019 | 0.023 | 0.037 | 0.029 | 0.031 | 0.335 | 0.034 | 0.007 | 0.051 | 0.075 | 1.000 | 0.021 | 0.079 |
| score_rec | 0.991 | 0.034 | 0.011 | 0.012 | 0.034 | 0.058 | 0.043 | 0.029 | 0.022 | 0.046 | 0.035 | 0.041 | 0.807 | 0.426 | 0.036 | 0.030 | 0.043 | 0.127 | 0.021 | 1.000 | 0.018 |
| score_montant | 0.023 | 0.041 | 0.071 | 0.121 | 0.129 | 0.043 | 0.096 | 0.026 | 0.171 | 0.140 | 0.149 | 0.141 | 0.024 | 0.430 | 0.041 | 0.014 | 0.041 | 0.219 | 0.079 | 0.018 | 1.000 |
| Unnamed: 0 | customer_id | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | date_achat | date_initial | diff_days | dummy | score_freq | score_rec | score_montant | score_rfm | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 08c5351a6aca1c1589a38f244edeee9d | b7d76e111c89f7ebf14761390f0f7d17 | 69309 | boa vista | RR | 2e7a8482f6fb09756ca50c10d7bfc047 | shipped | 2016-09-04 21:15:19 | 2016-10-07 13:18:03 | 2016-10-18 13:14:51 | NaN | 2016-10-20 00:00:00 | 2 | f293394c72c9b5fafd7023301fc21fc2 | 1554a68530182680ad5c8b042c3ab563 | 2016-10-26 18:25:19 | 32.90 | 31.67 | cef1ee03ded4d6272894a2eead6e1328 | 1 | NaN | 1 mes de atraso na entrega !!! ultima compra q faço | 2016-10-22 00:00:00 | 2016-11-15 16:00:34 | moveis_decoracao | 41.0 | 754.0 | 3.0 | 1800.0 | 32.0 | 6.0 | 28.0 | 2016-09-04 | 2016-09-04 | 0.0 | 1 | 1 | 1 | 3 | 5 |
| 1 | 1 | 08c5351a6aca1c1589a38f244edeee9d | b7d76e111c89f7ebf14761390f0f7d17 | 69309 | boa vista | RR | 2e7a8482f6fb09756ca50c10d7bfc047 | shipped | 2016-09-04 21:15:19 | 2016-10-07 13:18:03 | 2016-10-18 13:14:51 | NaN | 2016-10-20 00:00:00 | 1 | c1488892604e4ba5cff5b4eb4d595400 | 1554a68530182680ad5c8b042c3ab563 | 2016-10-26 18:25:19 | 39.99 | 31.67 | cef1ee03ded4d6272894a2eead6e1328 | 1 | NaN | 1 mes de atraso na entrega !!! ultima compra q faço | 2016-10-22 00:00:00 | 2016-11-15 16:00:34 | moveis_decoracao | 59.0 | 426.0 | 2.0 | 1400.0 | 32.0 | 6.0 | 28.0 | 2016-09-04 | 2016-09-04 | 0.0 | 1 | 1 | 1 | 3 | 5 |
| 2 | 2 | 683c54fc24d40ee9f8a6fc179fd9856c | 4854e9b3feff728c13ee5fc7d1547e92 | 99025 | passo fundo | RS | e5fa5a7210941f7d56d0208e4e071d35 | canceled | 2016-09-05 00:15:34 | 2016-10-07 13:17:15 | NaN | NaN | 2016-10-28 00:00:00 | 1 | f3c2d01a84c947b078e32bbef0718962 | a425f92c199eb576938df686728acd20 | 2016-09-19 00:15:34 | 59.50 | 15.56 | a93139d9d1314158c080e3db7e79618b | 1 | NaN | Comprei dois produtos desta loja parceira da lannister e nenhum foi entregue, ja faz Mais de dois meses e NEM Dao retorno ... | 2016-10-29 00:00:00 | 2016-10-30 01:47:48 | telefonia | 42.0 | 381.0 | 1.0 | 700.0 | 25.0 | 2.0 | 25.0 | 2016-09-05 | 2016-09-04 | 1.0 | 1 | 1 | 1 | 2 | 4 |
| 3 | 3 | 86dc2ffce2dfff336de2f386a786e574 | 830d5b7aaa3b6f1e9ad63703bec97d23 | 14600 | sao joaquim da barra | SP | bfbd0f9bdef84302105ad712db648a6c | delivered | 2016-09-15 12:16:38 | 2016-09-15 12:16:38 | 2016-11-07 17:11:53 | 2016-11-09 07:47:38 | 2016-10-04 00:00:00 | 3 | 5a6b04657a4c5ee34285d1e4619a96b4 | ecccfa2bb93b34a3bf033cc5d1dcdc69 | 2016-09-19 23:11:33 | 44.99 | 2.83 | 6916ca4502d6d3bfd39818759d55d536 | 1 | NaN | nao recebi o produto e nem resposta da empresa | 2016-10-06 00:00:00 | 2016-10-07 18:32:28 | beleza_saude | 34.0 | 1036.0 | 1.0 | 1000.0 | 16.0 | 16.0 | 16.0 | 2016-09-15 | 2016-09-04 | 11.0 | 1 | 1 | 1 | 4 | 6 |
| 4 | 4 | 86dc2ffce2dfff336de2f386a786e574 | 830d5b7aaa3b6f1e9ad63703bec97d23 | 14600 | sao joaquim da barra | SP | bfbd0f9bdef84302105ad712db648a6c | delivered | 2016-09-15 12:16:38 | 2016-09-15 12:16:38 | 2016-11-07 17:11:53 | 2016-11-09 07:47:38 | 2016-10-04 00:00:00 | 2 | 5a6b04657a4c5ee34285d1e4619a96b4 | ecccfa2bb93b34a3bf033cc5d1dcdc69 | 2016-09-19 23:11:33 | 44.99 | 2.83 | 6916ca4502d6d3bfd39818759d55d536 | 1 | NaN | nao recebi o produto e nem resposta da empresa | 2016-10-06 00:00:00 | 2016-10-07 18:32:28 | beleza_saude | 34.0 | 1036.0 | 1.0 | 1000.0 | 16.0 | 16.0 | 16.0 | 2016-09-15 | 2016-09-04 | 11.0 | 1 | 1 | 1 | 4 | 6 |
| 5 | 5 | 86dc2ffce2dfff336de2f386a786e574 | 830d5b7aaa3b6f1e9ad63703bec97d23 | 14600 | sao joaquim da barra | SP | bfbd0f9bdef84302105ad712db648a6c | delivered | 2016-09-15 12:16:38 | 2016-09-15 12:16:38 | 2016-11-07 17:11:53 | 2016-11-09 07:47:38 | 2016-10-04 00:00:00 | 1 | 5a6b04657a4c5ee34285d1e4619a96b4 | ecccfa2bb93b34a3bf033cc5d1dcdc69 | 2016-09-19 23:11:33 | 44.99 | 2.83 | 6916ca4502d6d3bfd39818759d55d536 | 1 | NaN | nao recebi o produto e nem resposta da empresa | 2016-10-06 00:00:00 | 2016-10-07 18:32:28 | beleza_saude | 34.0 | 1036.0 | 1.0 | 1000.0 | 16.0 | 16.0 | 16.0 | 2016-09-15 | 2016-09-04 | 11.0 | 1 | 1 | 1 | 4 | 6 |
| 6 | 6 | b106b360fe2ef8849fbbd056f777b4d5 | 0eb1ee9dba87f5b36b4613a65074337c | 2975 | sao paulo | SP | 71303d7e93b399f5bcd537d124c0bcfa | canceled | 2016-10-02 22:07:52 | 2016-10-06 15:50:56 | NaN | NaN | 2016-10-25 00:00:00 | 1 | d2998d7ced12f83f9b832f33cf6507b6 | 25e6ffe976bd75618accfe16cefcbd0d | 2016-10-21 16:19:54 | 100.00 | 9.34 | 34d62feeefaf60ef6ff7204af19fe109 | 1 | NaN | NaN | 2016-10-27 00:00:00 | 2016-10-27 23:40:51 | bebes | 32.0 | 561.0 | 1.0 | 500.0 | 18.0 | 18.0 | 18.0 | 2016-10-02 | 2016-09-04 | 28.0 | 1 | 1 | 1 | 3 | 5 |
| 7 | 7 | b8cf418e97ae795672d326288dfab7a7 | 8d3a54507421dbd2ce0a1d58046826e0 | 13185 | hortolandia | SP | d207cc272675637bfed0062edffd0818 | delivered | 2016-10-03 22:06:03 | 2016-10-04 10:28:07 | 2016-10-21 14:23:37 | 2016-10-31 11:07:42 | 2016-11-23 00:00:00 | 1 | 107177bf61755f05c604fe57e02467d6 | cca3071e3e9bb7d12640c9fbe2301306 | 2016-10-21 16:23:06 | 119.90 | 13.56 | 444d04d7ca0131b3b40619f81d0facd5 | 1 | NaN | Boa tarde o produto veio correto, porem a entrega é pessima precisei buscar em outra cidade.\r\nAcho absurdo se comprei pele internet e paguei o frete nao entendi porque nao entregar em minha residencia | 2016-11-01 00:00:00 | 2016-11-02 16:52:00 | moveis_decoracao | 55.0 | 130.0 | 1.0 | 2050.0 | 40.0 | 11.0 | 34.0 | 2016-10-03 | 2016-09-04 | 29.0 | 1 | 1 | 1 | 4 | 6 |
| 8 | 8 | 355077684019f7f60a031656bd7262b8 | 32ea3bdedab835c3aa6cb68ce66565ef | 4106 | sao paulo | SP | 3b697a20d9e427646d92567910af6d57 | delivered | 2016-10-03 09:44:50 | 2016-10-06 15:50:54 | 2016-10-23 14:02:13 | 2016-10-26 14:02:13 | 2016-10-27 00:00:00 | 1 | 3ae08df6bcbfe23586dd431c40bddbb7 | 522620dcb18a6b31cd7bdf73665113a9 | 2016-10-21 16:27:20 | 29.90 | 15.56 | 9fe0f66724df77fd63fcc0c94a323978 | 4 | NaN | Facilidade em manusear o aparelho. | 2016-10-26 00:00:00 | 2016-10-30 21:32:15 | relogios_presentes | 63.0 | 1642.0 | 3.0 | 300.0 | 16.0 | 16.0 | 16.0 | 2016-10-03 | 2016-09-04 | 29.0 | 1 | 1 | 1 | 1 | 3 |
| 9 | 9 | dc607dc98d6a11d5d04d9f2a70aa6c34 | 10e89fd8e5c745f81bec101207ba4d7d | 35162 | ipatinga | MG | ef1b29b591d31d57c0d7337460dd83c9 | delivered | 2016-10-03 22:51:30 | 2016-10-04 10:28:19 | 2016-10-21 14:23:36 | 2016-11-01 15:14:45 | 2016-11-25 00:00:00 | 1 | bfce5e847034e1fbbc1ed0bff6a372c7 | cca3071e3e9bb7d12640c9fbe2301306 | 2016-10-21 16:22:33 | 74.90 | 17.37 | a36150969fe6bd09ed011dd78aeb0189 | 1 | NaN | Demora na entrega, detestei o atendimento e NUNCA mais compro. baratheon quando vendia por eles mesmos era bem melhor! | 2016-11-02 00:00:00 | 2016-11-03 12:04:24 | moveis_decoracao | 55.0 | 248.0 | 1.0 | 1800.0 | 40.0 | 8.0 | 30.0 | 2016-10-03 | 2016-09-04 | 29.0 | 1 | 1 | 1 | 3 | 5 |
| Unnamed: 0 | customer_id | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | date_achat | date_initial | diff_days | dummy | score_freq | score_rec | score_montant | score_rfm | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112362 | 112362 | e450a297a7bc6839ceb0cf1a2377fa02 | 7a22d14aa3c3599238509ddca4b93b01 | 5863 | sao paulo | SP | 52018484704db3661b98ce838612b507 | delivered | 2018-08-29 12:25:59 | 2018-08-29 12:35:17 | 2018-08-29 13:38:00 | 2018-08-30 22:48:27 | 2018-09-03 00:00:00 | 1 | 777798445efd625458a90c13f3b3e6e7 | 5f2684dab12e59f83bef73ae57724e45 | 2018-08-31 12:35:17 | 63.90 | 9.20 | 7a11bf826668febba0800ec35884958c | 1 | Muito frágil !!! | Achei o produto muito pequeno e onde fica a "tela " com os botões do microondas sai com facilidade. Não tem um bom encaixe... | 2018-08-31 00:00:00 | 2018-09-21 13:54:38 | brinquedos | 52.0 | 711.0 | 2.0 | 1500.0 | 28.0 | 22.0 | 18.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 2 | 8 |
| 112363 | 112363 | b8c19e70d00f6927388e4f31c923d785 | 0c6d7218d5f3fa14514fd29865269993 | 9625 | sao bernardo do campo | SP | 912859fef5a0bd5059b6d48fa79d121a | delivered | 2018-08-29 09:48:09 | 2018-08-29 10:04:16 | 2018-08-29 19:01:00 | 2018-08-30 23:28:52 | 2018-09-04 00:00:00 | 1 | 9865c67a74684715521d1e70226cce0b | fa1c13f2614d7b5c4749cbc52fecda94 | 2018-09-03 10:04:16 | 169.80 | 8.45 | 728cca2fecca64b4f4cbf212bdc87319 | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-01 10:11:33 | relogios_presentes | 52.0 | 629.0 | 1.0 | 290.0 | 19.0 | 13.0 | 13.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 4 | 10 |
| 112364 | 112364 | 448945bc713d98b6726e82eda6249b9e | afbcfd0b9c5233e7ccc73428526fbb52 | 12243 | sao jose dos campos | SP | bee12e8653a04e76786e8891cfb6330a | delivered | 2018-08-29 08:46:11 | 2018-08-29 09:04:10 | 2018-08-29 13:03:00 | 2018-08-30 21:54:45 | 2018-09-11 00:00:00 | 4 | 8d4dac6177fb8134f26fb4c5cc6c0aff | c70c1b0d8ca86052f45a432a38b73958 | 2018-09-06 09:04:10 | 91.55 | 7.90 | 6b390a593dc8e574cc660146cf5366ec | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-01 16:57:41 | beleza_saude | 52.0 | 1649.0 | 1.0 | 250.0 | 22.0 | 5.0 | 15.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 5 | 11 |
| 112365 | 112365 | 56b1ac2855cc6d7950b4ffa6a9b41b0d | 0421e7a23f21e5d54efed456aedbc513 | 13322 | salto | SP | d03ca98f59480e7e76c71fa83ecd8fb6 | delivered | 2018-08-29 11:06:11 | 2018-08-29 11:24:02 | 2018-08-29 17:46:00 | 2018-08-30 23:56:54 | 2018-09-04 00:00:00 | 1 | 06601c3059e35a3bf65e72f2fd2ac626 | 6b90f847357d8981edd79a1eb1bf0acb | 2018-08-31 11:24:02 | 109.90 | 9.52 | 5c7d6b979aed548db0901cf9ffe3a2dc | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-03 13:58:54 | alimentos | 60.0 | 523.0 | 4.0 | 750.0 | 28.0 | 11.0 | 13.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 4 | 10 |
| 112366 | 112366 | c4c66f47534e09a03fc7a878a9eda5ea | f80013faf776e37bcea7634d59c2181e | 4716 | sao paulo | SP | c84d88553f9878bf2c7ecda2eb211ece | delivered | 2018-08-29 08:25:34 | 2018-08-29 08:44:13 | 2018-08-29 20:01:00 | 2018-08-30 16:56:24 | 2018-09-03 00:00:00 | 1 | 24bc2932a12c983f8e76d828b65cf39b | 5a413ade68e8f8d93071a7f52a64cb9e | 2018-08-31 08:44:13 | 65.00 | 9.21 | 2eac2da79f635ecf63675f93e9d95252 | 5 | Muito | O produto chegou mais rápido do que o esperado | 2018-08-31 00:00:00 | 2018-09-03 11:32:32 | beleza_saude | 12.0 | 2411.0 | 1.0 | 380.0 | 17.0 | 11.0 | 13.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 2 | 8 |
| 112367 | 112367 | 448945bc713d98b6726e82eda6249b9e | afbcfd0b9c5233e7ccc73428526fbb52 | 12243 | sao jose dos campos | SP | bee12e8653a04e76786e8891cfb6330a | delivered | 2018-08-29 08:46:11 | 2018-08-29 09:04:10 | 2018-08-29 13:03:00 | 2018-08-30 21:54:45 | 2018-09-11 00:00:00 | 5 | 8d4dac6177fb8134f26fb4c5cc6c0aff | c70c1b0d8ca86052f45a432a38b73958 | 2018-09-06 09:04:10 | 91.55 | 7.90 | 6b390a593dc8e574cc660146cf5366ec | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-01 16:57:41 | beleza_saude | 52.0 | 1649.0 | 1.0 | 250.0 | 22.0 | 5.0 | 15.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 5 | 11 |
| 112368 | 112368 | e60df9449653a95af4549bbfcb18a6eb | 5c58de6fb80e93396e2f35642666b693 | 80045 | curitiba | PR | 0b223d92c27432930dfe407c6aea3041 | delivered | 2018-08-29 14:18:23 | 2018-08-29 14:31:07 | 2018-08-29 15:29:00 | 2018-08-30 16:24:55 | 2018-09-04 00:00:00 | 2 | 2b4472df15512a2825ae86fd9ae79335 | 67bf6941ba2f1fa1d02c375766bc3e53 | 2018-08-31 14:30:19 | 209.00 | 46.48 | 6c50d16eb583d5db7e841b77e89b7045 | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-10-24 16:27:36 | moveis_cozinha_area_de_servico_jantar_e_jardim | 44.0 | 112.0 | 1.0 | 13550.0 | 48.0 | 49.0 | 49.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 5 | 11 |
| 112369 | 112369 | 448945bc713d98b6726e82eda6249b9e | afbcfd0b9c5233e7ccc73428526fbb52 | 12243 | sao jose dos campos | SP | bee12e8653a04e76786e8891cfb6330a | delivered | 2018-08-29 08:46:11 | 2018-08-29 09:04:10 | 2018-08-29 13:03:00 | 2018-08-30 21:54:45 | 2018-09-11 00:00:00 | 3 | 8d4dac6177fb8134f26fb4c5cc6c0aff | c70c1b0d8ca86052f45a432a38b73958 | 2018-09-06 09:04:10 | 91.55 | 7.90 | 6b390a593dc8e574cc660146cf5366ec | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-01 16:57:41 | beleza_saude | 52.0 | 1649.0 | 1.0 | 250.0 | 22.0 | 5.0 | 15.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 5 | 11 |
| 112370 | 112370 | 448945bc713d98b6726e82eda6249b9e | afbcfd0b9c5233e7ccc73428526fbb52 | 12243 | sao jose dos campos | SP | bee12e8653a04e76786e8891cfb6330a | delivered | 2018-08-29 08:46:11 | 2018-08-29 09:04:10 | 2018-08-29 13:03:00 | 2018-08-30 21:54:45 | 2018-09-11 00:00:00 | 1 | 8d4dac6177fb8134f26fb4c5cc6c0aff | c70c1b0d8ca86052f45a432a38b73958 | 2018-09-06 09:04:10 | 91.55 | 7.90 | 6b390a593dc8e574cc660146cf5366ec | 5 | NaN | NaN | 2018-08-31 00:00:00 | 2018-09-01 16:57:41 | beleza_saude | 52.0 | 1649.0 | 1.0 | 250.0 | 22.0 | 5.0 | 15.0 | 2018-08-29 | 2016-09-04 | 724.0 | 1 | 1 | 5 | 5 | 11 |
| 112371 | 112371 | 4b7decb9b58e2569548b8b4c8e20e8d7 | ff22e30958c13ffe219db7d711e8f564 | 2989 | sao paulo | SP | 54282e97f61c23b78330c15b154c867d | shipped | 2018-09-03 09:06:57 | 2018-09-03 17:40:06 | 2018-09-04 15:25:00 | NaN | 2018-09-06 00:00:00 | 1 | b98992ea80b467987a7fbb88e7f2076a | 25be943a321c8938947bdaabca979a90 | 2018-09-05 17:30:54 | 145.00 | 21.46 | 6efce984242ca6456d74750810733a03 | 1 | NaN | Nao recebi | 2018-08-31 00:00:00 | 2018-08-31 09:51:47 | moveis_cozinha_area_de_servico_jantar_e_jardim | 58.0 | 576.0 | 1.0 | 10400.0 | 16.0 | 68.0 | 32.0 | 2018-09-03 | 2016-09-04 | 729.0 | 1 | 1 | 5 | 4 | 10 |